Macro Scheduler in VBA code....

A

Ayato

Hi @ll,

I have a report that must be refreshed/saved and uploaded every 3
min... the manual process is running fine, just one click and go...

But now I am trying to build a Macro to schedule the process, anyon
have any piece of code that could help me?

What is the correct approach?
Do I need to have the workbook open 24/7 ?

Please advise,

regards,
Ayat
 
N

Nick Hodge

Ayato

Check out these two methods of the application object in VBA help

OnTime and Wait

If you need help on implementing these post back although the examples
should be enough for you. You will need to have the workbook open and the
code activated once.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
Top