running macro upon a spreadsheet's startup
 

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

running macro upon a spreadsheet's startup
 

Joe

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

Regards

Trevor


"Joe S." wrote in message
...
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

running macro upon a spreadsheet's startup
 

Awesome, thanks a bunch!