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: 553
Default Check to see if excel file has been saved

How do you check if an excel file has been saved in VBA? That is, if I have
an excel file open, what property tells me if the file has been saved yet?

I am thinking of an instance where I open a new workbook and forget to save
it. I want to run a macro that tells me that although the file is open, it
has not been saved yet.

Thanks
 
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
Excel File saved as Temp file DennisM New Users to Excel 1 January 7th 10 04:56 PM
Number Format on Excel File saved from .html file joyfulone Excel Discussion (Misc queries) 3 April 15th 09 12:07 AM
Saved *.csv file gives SYLK file type warning upon Excel 2003 open Tom Excel Discussion (Misc queries) 5 March 19th 08 03:15 PM
Can I reverse a saved file to the previous file in Excel? highlandmom Excel Discussion (Misc queries) 5 August 28th 07 04:10 PM
CSV file saved as Excel alma Excel Discussion (Misc queries) 3 March 21st 06 08:31 PM


All times are GMT +1. The time now is 06:16 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"