Sleep function between commands

**rishadjb** · 09-01-2009, 08:13 PM

I am writing a macro that copies some data from an excel sheet and pastes it into a browser text box.

I have everything figured out, and the code seems to working. Except that at some parts the commands are running so fast that they are not being executed in the proper order.

For example in the code below:

Please Login or Register  to view this content.

As you can see the macro switches to the explorer window, and then a Sendkey {TAB} command is used to move the cursor to the first textbox. However at times the sendkey command is executed so fast that the TAB is being applied in the excel window. I'm not sure if I am explaining this correctly, but that's what I observe.

I know there is a Sleep command to implement a wait time before the next command, but I don't know how to work that. Can someone please help me out here.

Thanks.

**stanleydgromjr** · 09-01-2009, 08:43 PM

rishadjb,

Try (you may have to adjust the 5000 delay):

Please Login or Register  to view this content.

**rishadjb** · 09-01-2009, 09:01 PM

Thanks Stanley.

I'll play around with the time and figure out the most appropriate one.

However, can you explain to me in what unit is this interval measured. As in this 5000, is it 5000 millisecs?

EDIT: Nvm, just saw the declaration at the top, that its in millisecs.