Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Read screen data with WshShell
Gentlemen, I have a small VBScript to automate certain tasks on an emulation screen. So, I have to move the cursor at one location, read the data and move on to the next, read that data (text or number) and copy that to Excel. I am able to move the cursor by WshShell.SendKeys method and copy... -
Jump out of loop when satisfied a condition
Skip, Thanks for a quick reply. OK, after plug in the main acct, I might have up to 10 or more sub accts, but the screen can only display up to 7 sub accts. It looks like this: - sub account 1 - sub account 2 ... - sub account 7 The code would select starting from sub account 1 at...- poem2004
- Post #3
- Forum: AttachMate solutions
-
Jump out of loop when satisfied a condition
Good morning, I have a macro that uses data from an excel column to plug into attachmate and then do further check from that data. On the attachmate screen, that customer might have more than one sub accounts. The code would go into each sub account and check for a status if it a yes, it...- poem2004
- Thread
- Replies: 3
- Forum: AttachMate solutions
-
Input from excel to attachmate
First, thanks for your tip Skip! There is a syntax error on this line: for each r in .range(.[A2], .[A2].end(xldown)) Should the format has an equal sign and "to" ? How do I use iCol that declared? I'll try to work around the code... Thanks again.- poem2004
- Post #3
- Forum: AttachMate solutions
-
Input from excel to attachmate
Gentlement: I have the code to grab data from a range of cells from excel, row by row and input to attachmate screen. The code works fine for a few rows, but I would like to see if we can add the 2 FOR loops to automatically run the macro until the end of data rows. Below is my code. Thanks...- poem2004
- Thread
- Replies: 3
- Forum: AttachMate solutions
