Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

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

Dose this link help?
http://www.ozgrid.com/VBA/prevent-save-prompt.htm
Reply With Quote
  #3  
Old 12-28-2005, 04:30 PM
Novice
 
Join Date: Nov 2005
Posts: 6
rnstewart
Default

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

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.
MSOfficeForums.com is not affiliated with Microsoft