Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
WorkbookOpen
I've tried using the help files, and the knowledge base,
but I can't figure out how to make this work. I've got a simple macro that I would like to run everytime a particular workbook is opened. It's just a routine that updates a query, and then refreshes a corresponding pivot table. It does this for 13 different queries and tables. I've got a macro that works fine, but I don't know how to make it run automatically when the workbook is opened. I don't understand class modules, application events, or any of this stuff that I've been reading. Please help! Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
WorkbookOpen
James,
The simplest way is to just name the macro Auto_Open. It will run whenever that workbook is opened. "James" wrote in message ... I've tried using the help files, and the knowledge base, but I can't figure out how to make this work. I've got a simple macro that I would like to run everytime a particular workbook is opened. It's just a routine that updates a query, and then refreshes a corresponding pivot table. It does this for 13 different queries and tables. I've got a macro that works fine, but I don't know how to make it run automatically when the workbook is opened. I don't understand class modules, application events, or any of this stuff that I've been reading. Please help! Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
WorkbookOpen
Thanks Chip, that was easy!
-----Original Message----- James, The simplest way is to just name the macro Auto_Open. It will run whenever that workbook is opened. "James" wrote in message ... I've tried using the help files, and the knowledge base, but I can't figure out how to make this work. I've got a simple macro that I would like to run everytime a particular workbook is opened. It's just a routine that updates a query, and then refreshes a corresponding pivot table. It does this for 13 different queries and tables. I've got a macro that works fine, but I don't know how to make it run automatically when the workbook is opened. I don't understand class modules, application events, or any of this stuff that I've been reading. Please help! Thanks. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open Find Dialog at WorkbookOpen | Excel Discussion (Misc queries) | |||
Unprotecting 4 sheets before "WorkbookOpen" macro runs | Excel Discussion (Misc queries) | |||
workbookopen doesn't function | Excel Discussion (Misc queries) | |||
WorkbookOpen() Auto macro | Excel Programming |