//flex table opened by JP

Click to See Complete Forum and Search --> : MS Word Macro help please


Johnski
02-14-2000, 03:05 AM
Hi there everyone.

1st post so I hope you'll be able to help.

I need to make a MS Word macro pause for a specific length of time, say a second for instance. How can I do this in a way that is not machine dependant, i.e. not just a for next loop that I've timed and tweaked that won't work on a faster/slower PC.

I looked at the Time function but it doesnt return seconds only hrs:mins.

I'm stumped.

Hope you're not stumped by this ;-)

Johnski
02-14-2000, 09:00 AM
help guys...dont let my post die the dead of zero replies!!

Mntsnow
02-14-2000, 11:46 AM
Well John, Here is a reply but I am not a Macro person so I have no answers for you put helping keep you nearer the top so hopefully someone with some Macro experiance can help http://www.sysopt.com/forum/smile.gif (btw have you checked in to some "office forums"?)

Mntsnow

Rich H
02-17-2000, 06:09 AM
I've never had to incorporate this into a macro before but I think you need to use the OnTime method i.e:

Sub PauseTimer()
Application.OnTime Now + TimeValue("00:00:20"), **"your macro"** End Sub

Hope this helps, if it doesn't then you should check out forums such as microsoft.public.excel.misc (as this is a general macro question) - guys like Tom Ogilvy and Nick Hodge will probably help you out. If you don't have a newsgroup reader then just go to www.deja.com (http://www.deja.com) and read the forums there.

Regards,
Rich