#1
|
|||
|
|||
Suppress "do you want to save?" dialog on close
I am writing a VBA app that does a batch HTML conversion of a large number of Excel spreadsheets. The idea is fairly simple: the user opens a file dialog to select all of the files he wants to convert, hits a button, and the program opens each file, selects a predefined portion of it, and saves it as a web page.
I seem to have it working nicely now, except for one annoying detail. Every time it closes a file, Excel brings up the "Do you want to save changes?" dialog, and the user has to hit the "No" button by hand. The app is not making any actual changes in the files; I assume it is only doing this because many of the files have data linked to other files, and whenever you open a spreadsheet with links in it, Excel automatically assumes that the file has changed and asks you to save when you close it. Is there any way I can suppress this dialog through VBA? I want this to be a nice, slick program that is easy to use and requires no attention once you set it running. I don't want the user to have to click "No" over and over again. |
#2
|
||||
|
||||
Dose this link help?
http://www.ozgrid.com/VBA/prevent-save-prompt.htm |
#3
|
|||
|
|||
Quote:
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
MYOB and "Item.Send error" Outlook message | peter_lambros | Outlook | 1 | 12-06-2008 08:24 AM |
"IF" "THEN" statements in Macros | mfgeng_iss | Misc | 0 | 10-04-2007 07:31 AM |
"open" or "open using" option not availa | ccd | Outlook | 0 | 09-22-2006 01:23 AM |
Use an "open" dialog box for selecting directories | rnstewart | Excel | 1 | 11-28-2005 06:24 PM |