WorkbookOpen

[James]

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.

 

[Chip Pearson]

James,

The simplest way is to just name the macro Auto_Open. It will
run whenever that workbook is opened.

 

[James]

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.






.