running macro upon a spreadsheet's startup

  • Thread starter Thread starter Joe S.
  • Start date Start date
J

Joe S.

In my quest to automate some of my files, I am trying to
run Excel files via window's "scheduled tasks." The
files I want to automate all have a macro that
refreshes/manipulates data, so I need to automate the
macro to run when the particular file is opened.

How can I automatically start a spreadsheet's macro when
I open up that spreadsheet?

Thanks for the help,
Joe
 
Joe

call the macro Auto_Open in a general module or use the Workbook_Open event
in the Workbook class module.

Regards

Trevor
 
Back
Top