Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Launch a VBA macro with opening a file
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 ... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Launch a VBA macro with opening a file
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 ... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Launch a VBA macro with opening a file
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 -- Regards, Tom Ogilvy "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 ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Launch new instance of Excel when opening .xls files | Excel Discussion (Misc queries) | |||
Can a macro be run on opening the file? | Excel Discussion (Misc queries) | |||
Can a macro be run on opening the file? | Excel Discussion (Misc queries) | |||
Opening excel from launch bar opens 2 existing files, not blank on | Excel Discussion (Misc queries) | |||
launch any file type from excel macro | Excel Programming |