Launch a VBA macro with opening a file

[LOLO53]

Hi,

I knew the "autopen" function under Excel 97.

But how do the same so easily with Excel 2002 ?

How to know which version of Excel is running ?

What are the different ways to launch a VBA macro with opening a file
(Ex : "autopen" with Excel 97, XXXX with Excel 2002, etc.)

Many thanks for your anwers ...

 

[Otto Moehrbach]

There are two ways. One is to place the macro in a regular module and name
the macro "AutoOpen". The other is to use the Workbook_Open macro in the
workbook module.
To find the version of Excel you have, select Help with a worksheet on
the screen. Select "About Microsoft Excel" from the drop-down menu. HTH
Otto

 

[Tom Ogilvy]

Auto_Open works with Excel 5 through and to the latest version (Excel 2003).

In xl97 and later you can use the workbook_Open event

see Chip Pearson's page on Events
http://www.cpearson.com/excel/events.htm