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
"LOLO53" wrote in message
om...
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 ...