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

Copy Attachmate screen area and paste in excel

Status
Not open for further replies.

Alpacino1

Technical User
Jan 19, 2013
2
GB
Hi,

Wonder if anyone can help me. I know how to get string (row,col,length)

And paste in excel.

How do you do a area say from (3,2) to (22,28) and paste into excel.

Thanks in advance
 
i don't use paste.

Code:
MyScreen = Sess.Area(1, 1, 24, 80)

Range("a1") = MyScreen

i could never get this to format correctly in excel so i hardly use this.

rem
 
...or you could even do this...
Code:
ActiveSheet.Range("a1").Value = YourScreenObject.Area(3, 2, 22, 28).Value


Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top