How to schedule a Macro ?

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro Scheduler in VBA code.... 1
Issue With Macro Sheduling Using On Time Event 0
Password locked with macro 1
how to hide .CSV file extension ? 10
Working of formula in Macro. 1
Accessing Exchange via Task Scheduler run on a Server 0
Open Save & Close Macro 3
does xcel have a built in scheduler ? 2

Top