[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1568
  • Last Modified:

use Record Macro to copy text from screen coordinates

On iSeries Access for Windows version 8, I am accessing an AS400.

I am trying to record a Macro using the "Record" function that will copy certain text.  I can press "control + v" during record to copy the entire screen, but I only want it to copy either coordinates or what I select with the mouse.

Any help would be great!
  • 2
1 Solution
cmushaunAuthor Commented:
sub subSub1_()

dim curcol, currow, maxcol, cval
curcol = 21
currow = 6
maxcol = autECLSession.autECLPS.NumCols
if (curcol > maxcol) then
exit do
end if
cval = autECLSession.autECLPS.GetText(currow, curcol, 1)
if (cval = " ") then
exit do
end if
autECLMacro "[mark right]"
curcol = curcol + 1
autECLMacro "[edit-copy]"

end sub
cmushaunAuthor Commented:
Figured it out myself, see above if interested

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now