Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
checking if file is saved
I would like to enter code to check if the file was saved before closing
I am using a form with a close button. 'check here if file has been saved first ?? Worksheets("StartupSheet").Activate Application.Quit |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
checking if file is saved
"John" wrote in message
... I would like to enter code to check if the file was saved before closing I am using a form with a close button. Hi John, If Not ActiveWorkbook.Saved Then ''' The workbook is not saved. Take action here. End If -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * "John" wrote in message ... I would like to enter code to check if the file was saved before closing I am using a form with a close button. 'check here if file has been saved first ?? Worksheets("StartupSheet").Activate Application.Quit |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number Format on Excel File saved from .html file | Excel Discussion (Misc queries) | |||
Saved *.csv file gives SYLK file type warning upon Excel 2003 open | Excel Discussion (Misc queries) | |||
How to tell number of spaces between values in saved text file fromthe original xls file | Excel Discussion (Misc queries) | |||
To get client data from a saved file back to the master file | Excel Discussion (Misc queries) | |||
File Checking | Excel Programming |