running macro upon a spreadsheet's startup

[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

 

[Trevor Shuttleworth]

Joe

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

Regards

Trevor

 

[Joe]

Awesome, thanks a bunch!