Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-28-2005, 03:11 PM
rnstewart rnstewart is offline
Novice
Suppress "do you want to save?" dialog on close
 
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 online now Suppress "do you want to save?" dialog on close Windows 10 Suppress "do you want to save?" dialog on close Office 2010
Admin
 
Join Date: Jan 2005
Posts: 429
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
rnstewart rnstewart is offline
Novice
Suppress "do you want to save?" dialog on close
 
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
Suppress "do you want to save?" dialog on close 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:13 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft