HELP - How do I know if a spreadsheet has been modified

L

LP

Hi all,

I am developing a C# application that uses an Excel object on a form. I
want to promt the user if he/she want to save the changes only if the
spreadsheet has been modified. Is there a FLAG somewhere in excel that
would tell me if it has been modified?

There must be because excel itself uses this when changes are made to a
sheet.

How can I identify that it has changed?

Thanks for all suggestions and replies!!!
 
B

Bill Barclift

xlApp.Saved

Saved Property

True if no changes have been made to the specified workbook since it was
last saved. Read/write Boolean.

Bill Barclift
 
L

LP

Works like a charm...thanks a million

LP


Bill Barclift said:
xlApp.Saved

Saved Property

True if no changes have been made to the specified workbook since it was
last saved. Read/write Boolean.

Bill Barclift
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How do I find what is in a spreadsheet 4
can't see VBA code, although it's working 0
How to modify the Query Tables attached to a sheet in a excelworkbook 3
Sub Workbook_Open not called when opening spreadsheet 6
Determine if the sheet has been changed 2
Update master spreadsheet from various single spreasheets 1
Store sheet names in Access 2

Top