Macro Scheduler in VBA code....

  • Thread starter Thread starter Ayato
  • Start date Start date
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
 
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
(e-mail address removed)
 
Back
Top