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")
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")