How to schedule a Macro ?
 

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

--
Message posted from http://www.ExcelForum.com

How to schedule a Macro ?
 

See Chip Pearson's webpage
http://www.cpearson.com/excel/ontime.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Ayato " wrote in message ...
Hi @ll,

I have a report that must be refreshed/saved and uploaded every 30
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, anyone
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,
Ayato


---
Message posted from http://www.ExcelForum.com/