MrExcel Publishing
Your One Stop for Excel Tips & Solutions

"auto-executing" Excel macro's

Posted by Sven Roels on August 31, 2001 5:25 AM

I have an Excel template with external data from a midrange system. I automated the weekly pivot report in it by saving it as a template. I want to go one step further and let the midrange schedule a pc command starting the template and executing a macro. Starting the template is ok, but does there something exist in Excel like an "AutoExec" macro (like in Access) ? I want the weekly reports to be made fully automatically (and if it's possible Excel can be run in the background)

Posted by Sven Roels on September 04, 2001 2:33 AM

==> solved the problem by writing little VB5 program that opens, fills, refreshes and saves the Excel file