Thread: WorkbookOpen
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
James[_14_] James[_14_] is offline
external usenet poster
 
Posts: 25
Default 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.