Jan 19, 2013 #1 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
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
Jan 21, 2013 #2 remy988 Technical User Mar 29, 2012 128 US 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 Upvote 0 Downvote
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
Jan 21, 2013 #3 S SkipVought Programmer Dec 4, 2001 47,487 US ...or you could even do this... Code: ActiveSheet.Range("a1").Value = YourScreenObject.Area(3, 2, 22, 28).Value Skip, Just traded in my old subtlety... for a NUANCE! Upvote 0 Downvote
...or you could even do this... Code: ActiveSheet.Range("a1").Value = YourScreenObject.Area(3, 2, 22, 28).Value Skip, Just traded in my old subtlety... for a NUANCE!
Jan 21, 2013 Thread starter #4 Alpacino1 Technical User Jan 19, 2013 2 GB Thanks for the reply people Upvote 0 Downvote