VBA - Staggering Macros and automation during buisness hours

[Johnnyv015]

Hello, I am fairly new to VBA and I am having trouble creating a code to do what I am looking to have done. First I will Explain then ill post the code as I have it.

I need to go to our company page, login, then pull data from reports generated from the company web sites. Then I will need to logout. I will need this macro to repeat itself every hour on the half hour during business hours.

Also the pulling of data from reports will have to be slightly staggered in order to not crash excel.

As of now I am able to log in and pull the data, I am just having problems automating this whole thing to run every hour and also to stagger the reports as to not overload excel.

Please help me get going in the right direction. THANKS!

Please Login or Register  to view this content.

[zbor]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[Johnnyv015]

So, as of now. I'm figuring that the best way to automate this to only run during business hours is going to be a start and stop button.

But I have no idea how to stagger the reports and logout to wait for the previous report to complete, also to run every hour. I'm sure this can be done. its just above my current skill set.

[Johnnyv015]

Anyone have any ideas on how I can automate this to run every hour and stagger the macros by a few minutes or seconds? Thanks!

[mehmetcik]

Use the ontime function.

Please Login or Register  to view this content.

[SamT]

In the first macro the runs, check the time and set OnTIme to either run in one hour or the next day and set the next macros OnTime to run in 2 minutes (or whatever,

In the rest of the macros, set the OnTIme for the Macro that run next. The last Macro doesn't set anything.

You can also use Wiindows Scheduler (Task Manager) to run the first macro