View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gareth[_6_] Gareth[_6_] is offline
external usenet poster
 
Posts: 158
Default Check to see if excel file has been saved

activeworkbook.saved (true or False)

G

ExcelMonkey wrote:
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