MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Auto Macros

Posted by Barry Conkey on February 13, 2002 6:20 AM

Is it possible to either run an Excel Macro at startup, such as an Access Macro? Or better yet, is it possible to run an Excel Macro using Microsoft Task Scheduler? I have a report that runs daily and it would be easier if I didn't have to open Excel and run the macro manually.

Posted by Ed Acosta on February 13, 2002 5:32 PM

Using task scheduler setup Excel to run when you want it to. Once it is setup right click on it go to properties. You should see where the program is calling up Excel. At the end of that line add the path to where your excel file is that contains the macro. It should look something like this "C:\PROGRAMFILES\MSOFFICE\EXCEL.exe C:\YOUR FOLDER\FILENAME.xls then create the macro to in the workbook on open event and it will run.