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!

cursor back in screen

Status
Not open for further replies.

braven

Programmer
May 20, 2009
58
CA
open excel sheet. but the cursor is in excel how do i have the cursor in active screen
here is the code. is that anything need to modify in this code
Set System = CreateObject("EXTRA.System")


Set Sessions = System.Sessions
Set Sess0 = System.ActiveSession
Set MyScreen = Sess0.Screen
Sess0.Connected = True


If (Sessions is Nothing) Then
Msgbox "Could not create the Sessions collection object. Stopping macro playback."
STOP
End If
Set appexcel = CreateObject("excel.application")
appExcel.Application.DisplayAlerts = False
appExcel.Visible = True
Close #1
Set wbExcel = appExcel.Workbooks.Open("c:\xyz\account.xls")

 
Try this at the end of your code

AppActivate "Session Name as it appears at the top of your session
 
Hi!
the session is already activate. but the cursor is showing in excel sheet. Need to check whether the screen is updating. for that the cursor should be in screen not in excel sheet. Appactivate is not going into.
 
Answered
sess0.activate
thanks for everyone
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top