If file name = 'abc', then run macro1

[dalex17]

Hi,

Is it possible to execute a specific macro depending on a file name? In other words, I have created macro1, macro2, and macro3, and would like for macro3 to run every time the file name abc.xls is opened.

Any replies would be much appreciated.

Please note that macro1, macro2 & macro3 are personal.xls macros and that the reason why I am trying to accomplish this is so that whenever file abc.xls is replaced (i.e. written over, saved over by another file, etc...), I will not not lose the functionality of the macro.

dalex

dalex

 

[Firery]

Create an Autpen macro for file ABC.xls in VB,
with macro3 within, when the file is opened the macro will execute automatically.