Is there a way to add a pause before a loop loops? For example:

for i=0 to 10

i=i+1

'pause for 10 seconds

next

Hi

You can try using sleep API function (

Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)

for i=0 to 10

i=i+1

'pause for 10 seconds
Sleep 10000 ' sleep is in milliseconds

next


) or use Application.Wait if it is Excel VBA (http://vbadud.blogspot.com/2008/03/s...excel-vba.html)

Cheers
Shasur

http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Hi there.. is there a point in trying to slowing the for...next??

Sleep is the perfect solution, but take in mind that if you sleep the thread, if will not receive even buttons events, so your program will look like frozen for about 100 seconds...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

This loop is in a .vbs script that is executed from the server using Taks Manager every min. Would the sleep function just affect the .vbs script or would it affect live websites on the server? Also, is it possible to have multiple instances of a .vbs script running? For ex, the script basically does this:

check database
if new user is true

for i=0 to 1000000

do something
i=i+1
sleep for 10 sec
next
end if

Every minute it should run and check to see if a new user has signed up and if so, run through the series of functions specifically for that user. These functions could take an extremely long time (days) to finish. If Task Manager is executing the vbs file every minute, is it executing a new instance or would it just ignore the request because it will see it as already running? Hope that makes sense. Also, how would the sleep function affect the program in this scenario?

Thanks for the help!

I don't think this is the best way to do this.. probably just a program (something like in vb 6)

I don't know what thing task manager do with a script, also I don't understand (me, maybe I lack that kind of info), how to run a script if you are not calling a page in the server.

IMHO, this is by far the worst solution to this...



HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

How are new users sighing up? I think there may be a better way to respond to that happening, but I need to know the method that is allowing them to sign up.