Oct 1, 2003 #1 Yesuslave Programmer Sep 24, 2003 28 US Hi all, So, in VBA through Excel, is there a way to get the current cursor location on the !Extra screen? Thanks, Joshua Wise
Hi all, So, in VBA through Excel, is there a way to get the current cursor location on the !Extra screen? Thanks, Joshua Wise
Oct 1, 2003 #2 NoLuckOnMyOwn Technical User Sep 26, 2003 3 US I copied this from the Extra help file and pasted it into an Excel module and it seemed to work. Sub Main() Dim Sys As Object, Sess As Object, MyScreen As Object Set Sys = CreateObject("EXTRA.System" ' Assumes an open session Set Sess = Sys.ActiveSession Set MyScreen = Sess.Screen CurrentRow = MyScreen.Row CurrentCol = MyScreen.Col MsgBox "The cursor is at " + Str$(CurrentRow) + "," + Str$(CurrentCol) + "." End Sub Copyright 1996 - 2000, Attachmate Corporation. All rights reserved. Upvote 0 Downvote
I copied this from the Extra help file and pasted it into an Excel module and it seemed to work. Sub Main() Dim Sys As Object, Sess As Object, MyScreen As Object Set Sys = CreateObject("EXTRA.System" ' Assumes an open session Set Sess = Sys.ActiveSession Set MyScreen = Sess.Screen CurrentRow = MyScreen.Row CurrentCol = MyScreen.Col MsgBox "The cursor is at " + Str$(CurrentRow) + "," + Str$(CurrentCol) + "." End Sub Copyright 1996 - 2000, Attachmate Corporation. All rights reserved.