Thread: Auto Execute Macro
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.worksheetfunctions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Auto Execute Macro
Record a macro when you do it manually.

Call this macro (or rename it) Auto_Open

Each time you open this workbook (and allow macros to run), the Auto_Open macro
will fire.

dennis wrote:

I'm looking to create a macro ( preferably using the macro recorder rather
than by VB code) that will refresh my database query upon opening the
worksheet.

Is this possible or just a pipe dream. I'm not adept at VB coding so that's
why the preference for the macro recorder.

Thanks in advance for any help, hints, or clues.

dennisd

--

Dave Peterson
Reply With QuoteReply With Quote