Search results for query: *

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...

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...

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...

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.

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...