LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 65
Default Toggling save warning message on or off

This is more of an Excel question than a VBA question, but....

I recently wrote a large VBA program that retrieves excel files (.xlsx) from a network directory, updates each file with downloaded system data, reduces the data, then writes the updated excel file back to its source location..

The source code is located in a separate macro-enabled file (.xlsm)

I've written numerous programs like this in the past with no issues. In this instance, opening up any of the modified files to view the updates results in a 'Do you want to save the changes...' pop-up upon exiting the file, even if there have been no changes.

Where in the system is this type of message being triggered from? I'm not finding any properties that flag this type of action.

The system is running Windows 7/MS Office 2007

Art
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
warning message cufc1210 Excel Discussion (Misc queries) 2 September 30th 09 11:48 PM
Warning Message Ewing25 Excel Programming 7 June 11th 08 08:27 PM
Warning Message tom Excel Discussion (Misc queries) 4 December 13th 06 08:23 PM
Warning Message MLK Excel Worksheet Functions 2 June 29th 06 11:55 AM
Pop up warning message! canix Excel Programming 1 August 5th 05 07:15 PM


All times are GMT +1. The time now is 09:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"