Good morning,
I am a beginner with the creation of scripts to speed up the export of tables from SAP to Excel.
I recorded this script and would like to try launching it directly via excel macro.
How can I do?
Thanks a lot to those who can help me out.
Greetings.
If Not IsObject(application) Then Set SapGuiAuto = GetObject("SAPGUI") Set application = SapGuiAuto.GetScriptingEngine End If If Not IsObject(connection) Then Set connection = application.Children(0) End If If Not IsObject(session) Then Set session = connection.Children(0) End If If IsObject(WScript) Then WScript.ConnectObject session, "on" WScript.ConnectObject application, "on" End If session.findById("wnd[0]").resizeWorkingPane 173,35,false session.findById("wnd[0]/tbar[0]/okcd").text = "cooispi" session.findById("wnd[0]").sendVKey 0 session.findById("wnd[0]/tbar[1]/btn[17]").press session.findById("wnd[1]/usr/txtV-LOW").text = "*pon*" session.findById("wnd[1]/usr/txtENAME-LOW").text = "" session.findById("wnd[1]/usr/txtENAME-LOW").setFocus session.findById("wnd[1]/usr/txtENAME-LOW").caretPosition = 0 session.findById("wnd[1]/tbar[0]/btn[8]").press session.findById("wnd[1]/usr/cntlALV_CONTAINER_1/shellcont/shell").currentCellRow = 7 session.findById("wnd[1]/usr/cntlALV_CONTAINER_1/shellcont/shell").selectedRows = "7" session.findById("wnd[1]/usr/cntlALV_CONTAINER_1/shellcont/shell").doubleClickCurrentCell session.findById("wnd[0]/tbar[1]/btn[8]").press session.findById("wnd[0]/usr/cntlCUSTOM/shellcont/shell/shellcont/shell").pressToolbarButton "&NAVIGATION_PROFILE_TOOLBAR_EXPAND" session.findById("wnd[0]/usr/cntlCUSTOM/shellcont/shell/shellcont/shell").pressToolbarContextButton "&MB_VARIANT" session.findById("wnd[0]/usr/cntlCUSTOM/shellcont/shell/shellcont/shell").pressToolbarContextButton "&MB_EXPORT" session.findById("wnd[0]/usr/cntlCUSTOM/shellcont/shell/shellcont/shell").selectContextMenuItem "&HTML" session.findById("wnd[1]/usr/ctxtDY_FILENAME").text = "cooispi.html" session.findById("wnd[1]/usr/ctxtDY_FILENAME").caretPosition = 12 session.findById("wnd[1]/tbar[0]/btn[11]").press session.findById("wnd[0]").close session.findById("wnd[1]/usr/btnSPOP-OPTION2").press