Solved

Turn off save confirmation for excel in VB6

Posted on 2002-05-01
3
163 Views
Last Modified: 2008-01-09
I've a VB program that populates an Excel sheet, prints it out, then closes it.

Every time it closes it's asking if I want to save my changes, which is always No.

How can I turn off the save confirmation and just have it dump the changes when it quits? It's VB controlling all of this, or if theres a way to turn it off just inside that 1 file, but I dont want a global change for all of Excel... just when I'm using this file.

Anyone?
0
Comment
Question by:edskee
  • 2
3 Comments
 
LVL 22

Accepted Solution

by:
Dreamboat earned 50 total points
ID: 6984297
On the Workbook Before Close, put:

Workbook.Saved = True

0
 
LVL 2

Author Comment

by:edskee
ID: 6984325
Thank you much!
0
 
LVL 22

Expert Comment

by:Dreamboat
ID: 6984396
:)
0

Featured Post

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
The blinking Office button 4 44
Dcount using a date in a table compared to today's date 3 30
sumifs excel 2013 3 15
ProperCase in Excel (Sheet) 3 10
In case Office 2010 has not been deployed in your environment, this article may be quite useful. In our office, we wanted a way to deploy Microsoft Office Professional Plus 2010 through an automated batch file via logon script. This article is docum…
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
The viewer will learn how to make their project stand out over others by learning how to change colors and shapes, add spaces, change directions, and add bullets to their charts.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question