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

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!!!

--

LP

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

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


"LP" wrote in message
...
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!!!

--

LP

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

Works like a charm...thanks a million

LP


"Bill Barclift" wrote in message
...
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


"LP" wrote in message
...
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!!!

--

LP