run macro outside excel

[frank_taos]

Hello:
I have a macro inside an excel 2007 workbook. I would like to know how I can run this macro from outside excel in a silent mode. I need to run the script (batch or vba) on an scheduler to clean a file that will be imported into access. Thanks in advance for your help.
Frank.

 

[Smitty]

Welcome to the Board!

Why not have Windows Scheduler open it then call your code in the Workbook_Open event.

HTH,

 

[frank_taos]

Thank you Smitty.
I am learning while I am solving it. I managed to put my code inside Private Sub Workbook_Open() and so I can test it while inside my vba environment and also every time I open my workbook. Now, if I want to save the Private Sub Workbook_Open() as a code module (i.e .exe) so I can call it from the scheduler, how should I do it? Sorry for such basic questions! Thanks a lot.
Frank.

 

[Smitty]

No worries.

You can't really compile VBA code, you'd need .NET for that. But if the code's in the Open event then when scheduler opens the wb the code's gonna' fire anyway, so it should do what you need.

 

[frank_taos]

Excellent, it worked. Thanks a lot.

 

[frank_taos]

Smitty: I need to schedule a similar task to import data in my Access DB. I created a macro using RunSavedImportExport, and I can run it inside Access 2007 and do the job. Now if I want this to run scheduled as in the Excel previous example, what would be the logic. Not sure if this is the place to ask. Thanks.
Frank

 

[Smitty]

You can probably use the OpenCurrentDatabase method.