Save

[eveCalypso]

Hello All,

A third party does a save to a document which contains some of my custom code.
I need to pick up within the document when its being saved.
Is there any way I can do that?

Any help would be appreciated!

Regards,

EvE

 

[AgatheB]

Select 'ThisWorkbook' in Microsoft Excel Objects and past the code below, or select from the dropdown menu...

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

End Sub

 

[eveCalypso]

Hello There,

Thank you for the tip, however, the reason I need to know when it has already been saved is because I need to pick up the new document's path.
So having code before the save won't help :-/

Regards,
EvE

 

[Simmy]

You could use Before_Close and then find the path of the workbook

Dave

 

[eveCalypso]

You are all so helpful - thank you
However (yet again!), I need the path before the document is closed.

Clearly I need some kind of event and a way to test whether the document has been saved.
Again, ANY suggestion would be appreciated. I am quite willing to code in an elaborate work-around if I required.

Rgds,
EvE