PAUSING A MACRO

Eddie G. · Jan 14th, 2002, 05:05 PM

it works great! thanks.

Eddie G. · Apr 12th, 2002, 01:17 PM

I have a macro that prints many sheets in a workbook. I want to be able to pause the macro for a specified amount of time so the printer buffer doesn't overrun. What line of code can I put in the macro to pause it.

thanks

Eddie G.

Mark O'Brien · Apr 12th, 2002, 01:19 PM

Use the "Wait" command. e.g. to stick in a 10 second pause:



Application.Wait(Now + TimeValue("0:00:10"))

Juan Pablo González · Apr 12th, 2002, 02:50 PM

Mark, I don't know if it works (I'm just guessing here) because if I remember correctly, the .Wait method pauses the entire application and possibly the system (Again, just guessing).... so, I'm not sure if the computer would still be able to keep processing the job.

Maybe, a for next that "simulates" the .Wait ? I don't know... maybe it DOES work !

Mark O'Brien · Apr 12th, 2002, 02:53 PM

I would think that it just pauses the application. You can use it to time keypresses if you ever get desperate enough to use the "SendKeys" command.

Then again, I'm not going to argue because maybe it doesn't work. I'm sure I've been proved wrong in the past. Just can't remember any specific instances.

tk19 · Apr 12th, 2002, 03:22 PM

fyi - i had a similar problem, and using application.wait as you wrote did work for me.

Apr 12th, 2002, 01:19 PM	#3
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Use the "Wait" command. e.g. to stick in a 10 second pause: Application.Wait(Now + TimeValue("0:00:10")) __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Apr 12th, 2002, 02:50 PM	#4
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Mark, I don't know if it works (I'm just guessing here) because if I remember correctly, the .Wait method pauses the entire application and possibly the system (Again, just guessing).... so, I'm not sure if the computer would still be able to keep processing the job. Maybe, a for next that "simulates" the .Wait ? I don't know... maybe it DOES work ! __________________ Regards, Juan Pablo González http://www.juanpg.com

Apr 12th, 2002, 02:53 PM	#5
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	I would think that it just pauses the application. You can use it to time keypresses if you ever get desperate enough to use the "SendKeys" command. Then again, I'm not going to argue because maybe it doesn't work. I'm sure I've been proved wrong in the past. Just can't remember any specific instances. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Jan 14th, 2002, 05:05 PM	#1
Eddie G. Board Regular Join Date: Feb 2002 Location: OKC Posts: 98	it works great! thanks.

Apr 12th, 2002, 01:17 PM	#2
Eddie G. Board Regular Join Date: Feb 2002 Location: OKC Posts: 98	I have a macro that prints many sheets in a workbook. I want to be able to pause the macro for a specified amount of time so the printer buffer doesn't overrun. What line of code can I put in the macro to pause it. thanks Eddie G.

Apr 12th, 2002, 03:22 PM	#6
tk19 New Member Join Date: Mar 2002 Posts: 33	fyi - i had a similar problem, and using application.wait as you wrote did work for me.