Timer to slow down macro

[stam]

Hello Mr Excel guru's,

First off, I'm a newbie to this site so please excuse anything that I'm doing wrong. I will learn and pick up the etiquettes. Here's my question: I want to slow down the run time of a macro via a timer. It seems like the macro hasn't completely finished performing its tasks after it is compiled. I'm not sure if it is a speed issue related to my computer or the company's network. All this macro is doing is open then print multiple workbooks, but the macro is running so fast some workbooks are not printed. I am on Excel 2010 in Windows 7. Thanks for any help.

 

[kpark91]

How about using methods like Application.Wait instead of timers?

 

[stam]

Thank you for the suggestion. I will give it a try. Is a mandatory parameter required? (ie Application.Wait(10). is 10 in seconds?)

 

[Michael M]

Hi Stam
Are you sure the speed of the macro is the problem ?
This example snippet will make the code wait 10 seconds between MsgBoxes.

Sub test()
MsgBox "1"
Application.Wait (Now + TimeValue("00:00:10"))
MsgBox "test"
End Sub

 

[stam]

Hi Michael,

I think your code will work for my situation, thanks for your input. I am now very excited to try it.

 

[stam]

Thank you everyone for looking at my question. The Application.Wait did the trick! Never thought I would complain about the computer running too fast.

 

[Michael M]

Glad you got it working....
Do you realise you can use the App.wait multiple times.

Sub test()
MsgBox "1"
Application.Wait (Now + TimeValue("00:00:10"))
MsgBox "2"
Application.Wait (Now + TimeValue("00:00:10"))
MsgBox "3"
End Sub