a doubt
 

I want to do something after a certain worksheet in excel is saved. Am
developing an automation addin to excel using c#, how can i
programmatically find out when a worksheet is saved? And, perform some
event(like, prompting the user: "you saved workbook.sheet* saved." when a
worksheet is saved?

a doubt
 

hi
you can't save just a worksheet. you have to save the whole workbook.
thisworkbook has a before save event that you might be able to use to prompt
the user.

regards
FSt1

"NA_AB" wrote:

I want to do something after a certain worksheet in excel is saved. Am
developing an automation addin to excel using c#, how can i
programmatically find out when a worksheet is saved? And, perform some
event(like, prompting the user: "you saved workbook.sheet* saved." when a
worksheet is saved?

a doubt
 

hey,

yep, i figured that out! :) thanks for replying... can we by any means know
programatically whether the user has chosen 'Yes' / 'No' from the pop-up 'Do
you want to save the changes made to ....xls?' whcih is shown when he clicks
the Close(X) button on the top right corner?!

Regards.

"FSt1" wrote:

hi
you can't save just a worksheet. you have to save the whole workbook.
thisworkbook has a before save event that you might be able to use to prompt
the user.

regards
FSt1

"NA_AB" wrote:

I want to do something after a certain worksheet in excel is saved. Am
developing an automation addin to excel using c#, how can i
programmatically find out when a worksheet is saved? And, perform some
event(like, prompting the user: "you saved workbook.sheet* saved." when a
worksheet is saved?