Auto-run macro after a save-as event

[Selma Li]

Hi,

I am trying to auto run a macro after I save a workbook. I'm picking u
where someone else is left off so I'm having some trouble following
I'll describe the situation and if you have a better sugguest, pleas
let me know. All help is appreciated!

There is an existing VB project that does a certain action. It wil
write data to an Excel spreadsheet and save it as a .xls. What I wan
to do is do some post-saving actions with a macro that I have alread
written in VBA.

I know that there's a auto_open that automatically open macro's upo
opening of a file. Is there any auto_?? that could detect the savin
of a file and run the macro specified?

Since I already developed the macro in VBA and it uses a lot of cel
references to the Excel spreadsheet, I want to link the VB applicatio
with excel. I want to have a template Excel file whch already contain
the VBA macro, have the VB application write to the template file, sav
the file as something else and run the VBA macro contained.

Or is it better to have the module imported to the excel spreadshee
automatically and run that after the save command in the VB script?

Thank you very very much

 

[Frank Kabel]

Hi
look at the workbook event BeforeSave for this