Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

LinkBack Thread Tools Display Modes
Old 12-28-2005, 03:11 PM
Join Date: Nov 2005
Posts: 6
Default 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.
Reply With Quote
Old 12-28-2005, 04:04 PM
Matrix's Avatar
Matrix Matrix is offline Windows 7 32bit Office 2010 32bit
Join Date: Jan 2005
Posts: 396
Matrix is on a distinguished road

Dose this link help?
Reply With Quote
Old 12-28-2005, 04:30 PM
Join Date: Nov 2005
Posts: 6

Originally Posted by Kevin
Works perfectly. Thanks for the quick response!
Reply With Quote

Thread Tools
Display Modes

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

All times are GMT -7. The time now is 12:19 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft