Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Running macros in Excel using scheduled task wizard

Status
Not open for further replies.

aarondewberry

IS-IT--Management
Jul 20, 2005
148
GB
All. I have a macro in a Excel spreadsheet which I need to run late at night. I have tried using the scheduled tasks wizard but have so far failed in my attempts to get this to work. Any ideas?
 
Why not set up an Excel file containing an "auto_open" macro that will run as the file is opened. Then set up a task opening that file at the desired time?
Rgds

ZH
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top