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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel VBA copying historic data from Attachmate session 2

Status
Not open for further replies.

MazzaB

Technical User
Feb 2, 2012
11
GB
With the help of this forum I've managed to write a short Macro that enters a router command into Attachmate from Excel and then copies the data returned back to Excel, my plan being to use this data to compile the next router command.
The problem is that the data that is copied back into Excel is historic data from the Attachmate session. I can post the code when I get to work but I dont think it is a problem with the VBA code but rather with Attachmate.
My Attachmate cursor always shows Row 25 and I cant move it to any other position on the screen. If I copy rows 1 to 25 to Excel for example it copies historic data so I tried rows 25 to 50 but it doesn't copy anything in addition to what I did previously.
I'm finding it impossible to copy the current data.
Do I need to copy the data as it comes into Attachmate rather than from the screen after the command is executed ?
 


Thanks for the direct feedback on the code I provided!!!

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
mazzaB, moving the cursor to another position ensures that after a successful find transaction, the cursor is moved back to where you would expect it.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top