Hi Guys,
I have a SAP-related macro issue couldn't fix by myself. I am dumping data out from SAP in the form of excel spreadsheet, so at the end of this macro it will pop-up a excel file, but after the extracting data macro finishes, it meant to call and run another macro, as you can see I put "Call move_data" at the end of this macro, but it doesn't work, everything just ends here.
Can anyone please advise me why everything I write after "session.findById("wnd[1]/tbar[0]/btn[11]").press" doesn't work at all? Is that because the pop-up excel file stops everything from running?
Any thoughts will be badly appreciated!
I have a SAP-related macro issue couldn't fix by myself. I am dumping data out from SAP in the form of excel spreadsheet, so at the end of this macro it will pop-up a excel file, but after the extracting data macro finishes, it meant to call and run another macro, as you can see I put "Call move_data" at the end of this macro, but it doesn't work, everything just ends here.
Can anyone please advise me why everything I write after "session.findById("wnd[1]/tbar[0]/btn[11]").press" doesn't work at all? Is that because the pop-up excel file stops everything from running?
Any thoughts will be badly appreciated!
VBA Code:
'export
session.findById("wnd[0]").maximize
session.findById("wnd[0]/mbar/menu[0]/menu[3]/menu[1]").Select
session.findById("wnd[1]/usr/ctxtDY_PATH").Text = "H:\General"
session.findById("wnd[1]/usr/ctxtDY_PATH").SetFocus
session.findById("wnd[1]/usr/ctxtDY_PATH").caretPosition = 93
session.findById("wnd[1]/tbar[0]/btn[11]").press --------------> pop-up a excel file
'it stops here --- why?
Call move_data
End Sub