MJB

Thanks everyone for the input. I tried the wait for web page to load but ended up using the website command, and just closing the page after every submit, it was slower but more reliable.

Can anyone tell me how to set focus to a web page form control (textbox). I've tried tabbing to it and also using cordinates but neither one of these methods seem to work consistantly because of page loading time differences. Any help would be much appreciated.

Thank you,

MJB

Thanks for the help Floyd! I'll give it a try. While I was waiting for a reply I went back and took out the Dynamic Variables Code and just performed all the Excel Functions within that same loop just using %T2% over and over... It seemed to work but still having problems with some other parts of the code unrelated to this thread. But thanks for all the help we really appreciate it!

Joe, I sent you an email, Thank you.

Thanks all,

MJB

Joe,

Yes please ! That would be great! We've been waiting on the book for two weeks so we've been having to learn a lot by trial and error, well at least until we found this great forum.

Thank you!

MJB

Thank you Floyd! Great explaination! The native code threw me off. So knowing this I should now be able to just do the reverse to get the values back out of the variables:

//Pseudo Code:
Repeat %N3% Times


Variable Modify Integer: Inc (%N2%)
Variable Set String %T3% "Text Type:<TMVAR2:09:%N2%:02:000:000:>"
Run Macro in Variable %T3%

End Repeat

// I know this isn't right but is the idea at least right?

Thanks again!

MJB

Hey Joe we ordered the book from Software Spectrum!

Thank you,

MJB

Hi Floyd,

I've been working with Rick on this Excel String Split and everything is working great, but could you explain this part of the code a little more:

// Increment the next "holding" variable and run the dynamic "Set Variable To" command
// "<TMVAR2:09:20:02:000:000:>".
Variable Modify Integer: Inc (%N2%)
Variable Set String %T3% "<TMVAR2:09:%N2%:02:000:000:>"
Run Macro in Variable %T3%

We've got all the tokens in the variables but now we'll need to get them back out. Can we add them to an array instead and then loop back through our array? We also downloaded the PGM Functions Library but as you can tell we are both Newbies when it comes to Macro Express, still waiting for our book to arrive.

Thanks for all your help!

MJB

P.S. I know that the code fragment above is assigning dynamic variables but what specifically is

"<TMVAR2:09:%N2%:02:000:000:>"

doing?