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
(e-mail address removed)
 

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

How to schedule a Macro ? 1
Macro: VBA code to move/forward email based on subjects and attachments 0
Macro to Run Functions and VBA code??? 0
Need VBA Macro to Loop through pages and print counter in footer of each page 9
How to make a macro write code into a slide ? 0
Accessing Exchange via Task Scheduler run on a Server 0
Using Scheduled Tasks to run Macros problem 2
Excel VBA Macro to do this? 19

Top