on 02-19-2014 4:34 PM
Hello guys!
I'm totaly new in this area, but I'm really excited about it!!
I need to export data from Excel to SAP (in a determinated function).
As example the sheet:
I need to fill the Sheet and use the macro that will use the informations that the sheet have in each row and create (for each row) a SAP Number (after this function, if I press enter it will generate a "Request ID") and put it automatically in the SAP ID Colum.
Is that even possible?
It will help me alot!!
I use SAP GUI.
Thx!!!!
Dear Marcus,
Yes it is possible.
First thing first, try and record the transaction using data from the first row via SAPGUI Script Recorder. From here you'll get all the object's ID used.
From there you can adjust your script to loop.
Thanks,
Sayuti
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for your help Sayuti!
I used the SAPGUI Script Recorder and here it is, the script:
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]").maximize
session.findById("wnd[0]/tbar[0]/okcd").text = "/nqm01"
session.findById("wnd[0]").sendVKey 0
session.findById("wnd[0]/usr/ctxtRIWO00-QMART").text = "WC"
session.findById("wnd[0]/usr/ctxtRIWO00-QMART").caretPosition = 2
session.findById("wnd[0]").sendVKey 0
session.findById("wnd[1]/usr/ctxtRQM01-MATNR").text = "XXXXX-1"
session.findById("wnd[1]/usr/ctxtRQM01-MAWERK").text = "XXXXX-2"
session.findById("wnd[1]/usr/ctxtRQM01-KUNUM").text = "XXXXX-3"
session.findById("wnd[1]/usr/ctxtRQM01-VKORG").text = "XXXXX-4"
session.findById("wnd[1]/usr/ctxtRQM01-VTWEG").text = "01"
session.findById("wnd[1]/usr/ctxtRQM01-SPART").text = "01"
session.findById("wnd[1]/usr/ctxtRQM01-SPART").setFocus
session.findById("wnd[1]/usr/ctxtRQM01-SPART").caretPosition = 2
session.findById("wnd[1]").sendVKey 0
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB01/ssubSUB_GROUP_10:SAPLIQS0:7235/subCUSTOM_SCREEN:SAPLIQS0:7212/subSUBSCREEN_2:SAPLIQS0:7900/subUSER0001:SAPLXQQM:0101/ctxtVIQMEL-ZZWERK").text = "XXXXX-5"
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB01/ssubSUB_GROUP_10:SAPLIQS0:7235/subCUSTOM_SCREEN:SAPLIQS0:7212/subSUBSCREEN_2:SAPLIQS0:7900/subUSER0001:SAPLXQQM:0101/txtVIQMEL-ZZASDT2").text = "XXXXX-6"
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB01/ssubSUB_GROUP_10:SAPLIQS0:7235/subCUSTOM_SCREEN:SAPLIQS0:7212/subSUBSCREEN_2:SAPLIQS0:7900/subUSER0001:SAPLXQQM:0101/txtVIQMEL-ZZ0KMG").text = "XXXXX-7"
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB01/ssubSUB_GROUP_10:SAPLIQS0:7235/subCUSTOM_SCREEN:SAPLIQS0:7212/subSUBSCREEN_4:SAPLIQS0:7740/subBELEG:SAPMQM00:3001/txtVIQMEL-REFNUM").text = "XXXXX-8"
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB01/ssubSUB_GROUP_10:SAPLIQS0:7235/subCUSTOM_SCREEN:SAPLIQS0:7212/subSUBSCREEN_4:SAPLIQS0:7740/subBELEG:SAPMQM00:3001/ctxtVIQMEL-BSTDK").text = "XXXXX-9"
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB01/ssubSUB_GROUP_10:SAPLIQS0:7235/subCUSTOM_SCREEN:SAPLIQS0:7212/subSUBSCREEN_4:SAPLIQS0:7740/subBELEG:SAPMQM00:3001/ctxtVIQMEL-BSTDK").setFocus
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB01/ssubSUB_GROUP_10:SAPLIQS0:7235/subCUSTOM_SCREEN:SAPLIQS0:7212/subSUBSCREEN_4:SAPLIQS0:7740/subBELEG:SAPMQM00:3001/ctxtVIQMEL-BSTDK").caretPosition = 10
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB02").select
session.findById("wnd[0]").sendVKey 4
session.findById("wnd[1]/usr/cntlTREE_CONTROL_AREA/shellcont/shell").selectedNode = " 7"
session.findById("wnd[1]/usr/cntlTREE_CONTROL_AREA/shellcont/shell").doubleClickNode " 7"
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB02/ssubSUB_GROUP_10:SAPLIQS0:7235/subCUSTOM_SCREEN:SAPLIQS0:7212/subSUBSCREEN_2:SAPLIQS0:7710/txtRIWO00-HEADKTXT").text = "XXXXX-10"
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB02/ssubSUB_GROUP_10:SAPLIQS0:7235/subCUSTOM_SCREEN:SAPLIQS0:7212/subSUBSCREEN_2:SAPLIQS0:7710/tblSAPLIQS0TEXT/txtLTXTTAB2-TLINE[0,0]").text = "XXXXX-11"
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB02/ssubSUB_GROUP_10:SAPLIQS0:7235/subCUSTOM_SCREEN:SAPLIQS0:7212/subSUBSCREEN_3:SAPLIQS0:7750/txtVIQMEL-RKMNG").text = "1"
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB02/ssubSUB_GROUP_10:SAPLIQS0:7235/subCUSTOM_SCREEN:SAPLIQS0:7212/subSUBSCREEN_3:SAPLIQS0:7750/txtVIQMEL-BZMNG").text = "1"
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB02/ssubSUB_GROUP_10:SAPLIQS0:7235/subCUSTOM_SCREEN:SAPLIQS0:7212/subSUBSCREEN_3:SAPLIQS0:7750/txtVIQMEL-RGMNG").text = "1"
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB02/ssubSUB_GROUP_10:SAPLIQS0:7235/subCUSTOM_SCREEN:SAPLIQS0:7212/subSUBSCREEN_3:SAPLIQS0:7750/txtVIQMEL-RGMNG").setFocus
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB02/ssubSUB_GROUP_10:SAPLIQS0:7235/subCUSTOM_SCREEN:SAPLIQS0:7212/subSUBSCREEN_3:SAPLIQS0:7750/txtVIQMEL-RGMNG").caretPosition = 1
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB03").select
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB03/ssubSUB_GROUP_10:SAPLIQS0:7235/subCUSTOM_SCREEN:SAPLIQS0:7212/subSUBSCREEN_2:SAPLIQS0:7900/subUSER0001:SAPLXQQM:0102/ctxtVIQMEL-ZZRESP").text = "WBR-CQ"
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB03/ssubSUB_GROUP_10:SAPLIQS0:7235/subCUSTOM_SCREEN:SAPLIQS0:7212/subSUBSCREEN_2:SAPLIQS0:7900/subUSER0001:SAPLXQQM:0102/txtVIQMEL-ZZRPLT").text = "XXXXX-12"
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB03/ssubSUB_GROUP_10:SAPLIQS0:7235/subCUSTOM_SCREEN:SAPLIQS0:7212/subSUBSCREEN_2:SAPLIQS0:7900/subUSER0001:SAPLXQQM:0102/txtVIQMEL-ZZRPLT").setFocus
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB03/ssubSUB_GROUP_10:SAPLIQS0:7235/subCUSTOM_SCREEN:SAPLIQS0:7212/subSUBSCREEN_2:SAPLIQS0:7900/subUSER0001:SAPLXQQM:0102/txtVIQMEL-ZZRPLT").caretPosition = 7
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB04").select
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB04/ssubSUB_GROUP_10:SAPLIQS0:7316/txtVIQMEL-QMNAM").text = "Marcus Alves"
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB04/ssubSUB_GROUP_10:SAPLIQS0:7316/txtVIQMEL-QMNAM").caretPosition = 12
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB10").select
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB10/ssubSUB_GROUP_10:SAPLIQS0:7210/tabsTAB_GROUP_20/tabp20\TAB01/ssubSUB_GROUP_20:SAPLIQS0:7110/tblSAPLIQS0POSITION_VIEWER/ctxtVIQMFE-BAUTL[1,0]").setFocus
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB10/ssubSUB_GROUP_10:SAPLIQS0:7210/tabsTAB_GROUP_20/tabp20\TAB01/ssubSUB_GROUP_20:SAPLIQS0:7110/tblSAPLIQS0POSITION_VIEWER/ctxtVIQMFE-BAUTL[1,0]").caretPosition = 0
session.findById("wnd[0]").sendVKey 4
session.findById("wnd[1]").close
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB10/ssubSUB_GROUP_10:SAPLIQS0:7210/tabsTAB_GROUP_20/tabp20\TAB01/ssubSUB_GROUP_20:SAPLIQS0:7110/tblSAPLIQS0POSITION_VIEWER/ctxtVIQMFE-BAUTL[1,0]").text = "XXXXX-13"
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB10/ssubSUB_GROUP_10:SAPLIQS0:7210/tabsTAB_GROUP_20/tabp20\TAB01/ssubSUB_GROUP_20:SAPLIQS0:7110/tblSAPLIQS0POSITION_VIEWER/txtVIQMFE-FMGFRD[2,0]").text = "1"
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB10/ssubSUB_GROUP_10:SAPLIQS0:7210/tabsTAB_GROUP_20/tabp20\TAB01/ssubSUB_GROUP_20:SAPLIQS0:7110/tblSAPLIQS0POSITION_VIEWER/ctxtVIQMFE-FECOD[3,0]").setFocus
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB10/ssubSUB_GROUP_10:SAPLIQS0:7210/tabsTAB_GROUP_20/tabp20\TAB01/ssubSUB_GROUP_20:SAPLIQS0:7110/tblSAPLIQS0POSITION_VIEWER/ctxtVIQMFE-FECOD[3,0]").caretPosition = 0
session.findById("wnd[0]").sendVKey 4
session.findById("wnd[1]/usr/cntlTREE_CONTROL_AREA/shellcont/shell").expandNode " 75"
session.findById("wnd[1]/usr/cntlTREE_CONTROL_AREA/shellcont/shell").topNode = " 1"
session.findById("wnd[1]/usr/cntlTREE_CONTROL_AREA/shellcont/shell").selectedNode = " 78"
session.findById("wnd[1]/usr/cntlTREE_CONTROL_AREA/shellcont/shell").doubleClickNode " 78"
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB10/ssubSUB_GROUP_10:SAPLIQS0:7210/tabsTAB_GROUP_20/tabp20\TAB01/ssubSUB_GROUP_20:SAPLIQS0:7110/tblSAPLIQS0POSITION_VIEWER/cmbVIQMFE-FEQKLAS[7,0]").key = "99"
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB10/ssubSUB_GROUP_10:SAPLIQS0:7210/tabsTAB_GROUP_20/tabp20\TAB01/ssubSUB_GROUP_20:SAPLIQS0:7110/tblSAPLIQS0POSITION_VIEWER/ctxtVIQMFE-OTGRP[10,0]").setFocus
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB10/ssubSUB_GROUP_10:SAPLIQS0:7210/tabsTAB_GROUP_20/tabp20\TAB01/ssubSUB_GROUP_20:SAPLIQS0:7110/tblSAPLIQS0POSITION_VIEWER/ctxtVIQMFE-OTGRP[10,0]").caretPosition = 0
session.findById("wnd[0]").sendVKey 4
session.findById("wnd[1]/usr/cntlTREE_CONTROL_AREA/shellcont/shell").selectItem " 8","1"
session.findById("wnd[1]/usr/cntlTREE_CONTROL_AREA/shellcont/shell").ensureVisibleHorizontalItem " 8","1"
session.findById("wnd[1]/usr/cntlTREE_CONTROL_AREA/shellcont/shell").doubleClickItem " 8","1"
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB10/ssubSUB_GROUP_10:SAPLIQS0:7210/tabsTAB_GROUP_20/tabp20\TAB04").select
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB10/ssubSUB_GROUP_10:SAPLIQS0:7210/tabsTAB_GROUP_20/tabp20\TAB04/ssubSUB_GROUP_20:SAPLIQS0:7135/tblSAPLIQS0AKTIONEN_VIEWER2/ctxtVIQMMA-MNGRP[1,0]").setFocus
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB10/ssubSUB_GROUP_10:SAPLIQS0:7210/tabsTAB_GROUP_20/tabp20\TAB04/ssubSUB_GROUP_20:SAPLIQS0:7135/tblSAPLIQS0AKTIONEN_VIEWER2/ctxtVIQMMA-MNGRP[1,0]").caretPosition = 0
session.findById("wnd[0]").sendVKey 4
session.findById("wnd[1]/usr/cntlTREE_CONTROL_AREA/shellcont/shell").expandNode " 52"
session.findById("wnd[1]/usr/cntlTREE_CONTROL_AREA/shellcont/shell").topNode = " 1"
session.findById("wnd[1]/usr/cntlTREE_CONTROL_AREA/shellcont/shell").selectItem " 53","1"
session.findById("wnd[1]/usr/cntlTREE_CONTROL_AREA/shellcont/shell").ensureVisibleHorizontalItem " 53","1"
session.findById("wnd[1]/usr/cntlTREE_CONTROL_AREA/shellcont/shell").doubleClickItem " 53","1"
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB10/ssubSUB_GROUP_10:SAPLIQS0:7210/tabsTAB_GROUP_20/tabp20\TAB04/ssubSUB_GROUP_20:SAPLIQS0:7135/tblSAPLIQS0AKTIONEN_VIEWER2/txtVIQMMA-MATXT[4,0]").setFocus
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB10/ssubSUB_GROUP_10:SAPLIQS0:7210/tabsTAB_GROUP_20/tabp20\TAB04/ssubSUB_GROUP_20:SAPLIQS0:7135/tblSAPLIQS0AKTIONEN_VIEWER2/txtVIQMMA-MATXT[4,0]").caretPosition = 0
session.findById("wnd[0]").sendVKey 2
session.findById("wnd[1]").close
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB10/ssubSUB_GROUP_10:SAPLIQS0:7210/tabsTAB_GROUP_20/tabp20\TAB04/ssubSUB_GROUP_20:SAPLIQS0:7135/tblSAPLIQS0AKTIONEN_VIEWER2/btnQMICON-LTAKTION[5,0]").setFocus
session.findById("wnd[0]/usr/tabsTAB_GROUP_10/tabp10\TAB10/ssubSUB_GROUP_10:SAPLIQS0:7210/tabsTAB_GROUP_20/tabp20\TAB04/ssubSUB_GROUP_20:SAPLIQS0:7135/tblSAPLIQS0AKTIONEN_VIEWER2/btnQMICON-LTAKTION[5,0]").press
session.findById("wnd[0]/usr/cntlSCMSW_CONTAINER_2102/shellcont/shell").setDocument 1,"e1xydGYxXGFkZWZsYW5nMTAyNVxhbnNpXGFuc2ljcGcxMjUyXHVjMVxhZGVmZjBcZGVmZjBcc3RzaGZkYmNoMFxzdHNoZmxvY2gwXHN0c2hmaGljaDBcc3RzaGZiaTBcZGVmbGFuZzEwNDZcZGVmbGFuZ2ZlMTA0MntcZm9udHRibHtcZjBcZnJvbWFuXGZjaGFyc2V0MFxmcHJxMntcKlxwYW5vc2UgMDIwMjA2MDMwNTA0MDUwMjAzMDR9VGltZXMgTmV3IFJvbWFuO317XGYyXGZtb2Rlcm5cZmNoYXJzZXQwXGZwcnExe1wqXHBhbm9zZSAwMjA3MDMwOTAyMDIwNTAyMDQwNH1Db3VyaWVyIE5ldzt9e1xmNDFcZnJvbWFuXGZjaGFyc2V0MjM4XGZwcnEyIFRpbWVzIE5ldyBSb21hbiBDRTt9DQp7XGY0Mlxmcm9tYW5cZmNoYXJzZXQyMDRcZnBycTIgVGltZXMgTmV3IFJvbWFuIEN5cjt9e1xmNDRcZnJvbWFuXGZjaGFyc2V0MTYxXGZwcnEyIFRpbWVzIE5ldyBSb21hbiBHcmVlazt9e1xmNDVcZnJvbWFuXGZjaGFyc2V0MTYyXGZwcnEyIFRpbWVzIE5ldyBSb21hbiBUdXI7fXtcZjQ2XGZiaWRpIFxmcm9tYW5cZmNoYXJzZXQxNzdcZnBycTIgVGltZXMgTmV3IFJvbWFuIChIZWJyZXcpO30NCntcZjQ3XGZiaWRpIFxmcm9tYW5cZmNoYXJzZXQxNzhcZnBycTIgVGltZXMgTmV3IFJvbWFuIChBcmFiaWMpO317XGY0OFxmcm9tYW5cZmNoYXJzZXQxODZcZnBycTIgVGltZXMgTmV3IFJvbWFuIEJhbHRpYzt9e1xmNDlcZnJvbWFuXGZjaGFyc2V0MTYzXGZwcnEyIFRpbWVzIE5ldyBSb21hbiAoVmlldG5hbWVzZSk7fXtcZjYxXGZtb2Rlcm5cZmNoYXJzZXQyMzhcZnBycTEgQ291cmllciBOZXcgQ0U7fQ0Ke1xmNjJcZm1vZGVyblxmY2hhcnNldDIwNFxmcHJxMSBDb3VyaWVyIE5ldyBDeXI7fXtcZjY0XGZtb2Rlcm5cZmNoYXJzZXQxNjFcZnBycTEgQ291cmllciBOZXcgR3JlZWs7fXtcZjY1XGZtb2Rlcm5cZmNoYXJzZXQxNjJcZnBycTEgQ291cmllciBOZXcgVHVyO317XGY2NlxmYmlkaSBcZm1vZGVyblxmY2hhcnNldDE3N1xmcHJxMSBDb3VyaWVyIE5ldyAoSGVicmV3KTt9DQp7XGY2N1xmYmlkaSBcZm1vZGVyblxmY2hhcnNldDE3OFxmcHJxMSBDb3VyaWVyIE5ldyAoQXJhYmljKTt9e1xmNjhcZm1vZGVyblxmY2hhcnNldDE4NlxmcHJxMSBDb3VyaWVyIE5ldyBCYWx0aWM7fXtcZjY5XGZtb2Rlcm5cZmNoYXJzZXQxNjNcZnBycTEgQ291cmllciBOZXcgKFZpZXRuYW1lc2UpO319e1xjb2xvcnRibDtccmVkMFxncmVlbjBcYmx1ZTA7XHJlZDBcZ3JlZW4wXGJsdWUyNTU7XHJlZDBcZ3JlZW4yNTVcYmx1ZTI1NTsNClxyZWQwXGdyZWVuMjU1XGJsdWUwO1xyZWQyNTVcZ3JlZW4wXGJsdWUyNTU7XHJlZDI1NVxncmVlbjBcYmx1ZTA7XHJlZDI1NVxncmVlbjI1NVxibHVlMDtccmVkMjU1XGdyZWVuMjU1XGJsdWUyNTU7XHJlZDBcZ3JlZW4wXGJsdWUxMjg7XHJlZDBcZ3JlZW4xMjhcYmx1ZTEyODtccmVkMFxncmVlbjEyOFxibHVlMDtccmVkMTI4XGdyZWVuMFxibHVlMTI4O1xyZWQxMjhcZ3JlZW4wXGJsdWUwO1xyZWQxMjhcZ3JlZW4xMjhcYmx1ZTA7DQpccmVkMTI4XGdyZWVuMTI4XGJsdWUxMjg7XHJlZDE5MlxncmVlbjE5MlxibHVlMTkyO317XHN0eWxlc2hlZXR7XHFsIFxsaTBccmkwXHdpZGN0bHBhclxhc3BhbHBoYVxhc3BudW1cZmFhdXRvXGFkanVzdHJpZ2h0XHJpbjBcbGluMFxpdGFwMCBccnRsY2hcZmNzMSBcYWYwXGFmczI0XGFsYW5nMTAyNSBcbHRyY2hcZmNzMCBcZnMyNFxsYW5nMTA0NlxsYW5nZmUxMDQyXGNncmlkXGxhbmducDEwNDZcbGFuZ2ZlbnAxMDQyIA0KXHNuZXh0MCBcc3NlbWloaWRkZW4gTm9ybWFsO317XCpcY3MxMCBcYWRkaXRpdmUgXHNzZW1paGlkZGVuIERlZmF1bHQgUGFyYWdyYXBoIEZvbnQ7fXtcKg0KXHRzMTFcdHNyb3dkXHRyZnRzV2lkdGhCM1x0cnBhZGRsMTA4XHRycGFkZHIxMDhcdHJwYWRkZmwzXHRycGFkZGZ0M1x0cnBhZGRmYjNcdHJwYWRkZnIzXHRyY2JwYXQxXHRyY2ZwYXQxXHRzY2VsbHdpZHRoZnRzMFx0c3ZlcnRhbHRcdHNicmRydFx0c2JyZHJsXHRzYnJkcmJcdHNicmRyclx0c2JyZHJkZ2xcdHNicmRyZGdyXHRzYnJkcmhcdHNicmRydiANClxxbCBcbGkwXHJpMFx3aWRjdGxwYXJcYXNwYWxwaGFcYXNwbnVtXGZhYXV0b1xhZGp1c3RyaWdodFxyaW4wXGxpbjBcaXRhcDAgXHJ0bGNoXGZjczEgXGFmMFxhZnMyMCBcbHRyY2hcZmNzMCBcZnMyMFxsYW5nMTAyNFxsYW5nZmUxMDI0XGNncmlkXGxhbmducDEwMjRcbGFuZ2ZlbnAxMDI0IFxzbmV4dDExIFxzc2VtaWhpZGRlbiBOb3JtYWwgVGFibGU7fXtcKlxjczE1IFxhZGRpdGl2ZSBcYiBIIEhpZ2hsaWdodDt9e1wqXGNzMTYgXGFkZGl0aXZlIA0KXHVsIFUgVW5kZXJsaW5lO317XHMxN1xxaiBcbGkwXHJpMFxzbDI0MFxzbG11bHQwXG5vd2lkY3RscGFyXGZhYXV0b1xyaW4wXGxpbjBcaXRhcDAgXHJ0bGNoXGZjczEgXGFmMlxhZnMyNFxhbGFuZzEwMjUgXGx0cmNoXGZjczAgXGYyXGZzMjRcbGFuZzEwMzNcbGFuZ2ZlMTA0MlxjZ3JpZFxsYW5nbnAxMDMzXGxhbmdmZW5wMTA0MiBcc25leHQxNyBCIEJsb2NrO317XHMxOFxxYyBcbGkwXHJpMFxzbDI0MFxzbG11bHQwDQpcbm93aWRjdGxwYXJcZmFhdXRvXHJpbjBcbGluMFxpdGFwMCBccnRsY2hcZmNzMSBcYWYyXGFmczI0XGFsYW5nMTAyNSBcbHRyY2hcZmNzMCBcZjJcZnMyNFxsYW5nMTAzM1xsYW5nZmUxMDQyXGNncmlkXGxhbmducDEwMzNcbGFuZ2ZlbnAxMDQyIFxzbmV4dDE4IEMgQ2VudGVyO317XHMxOVxxbCBcbGkwXHJpMFxzbDI0MFxzbG11bHQwXG5vd2lkY3RscGFyXGZhYXV0b1xyaW4wXGxpbjBcaXRhcDAgXHJ0bGNoXGZjczEgDQpcYWYyXGFmczI0XGFsYW5nMTAyNSBcbHRyY2hcZmNzMCBcZjJcZnMyNFxsYW5nMTAzM1xsYW5nZmUxMDQyXGNncmlkXGxhbmducDEwMzNcbGFuZ2ZlbnAxMDQyIFxzbmV4dDE5IEwgTGVmdCBKdXN0aWZpZWQ7fXtcczIwXHFsIFxsaTBccmkwXHNsMjQwXHNsbXVsdDBcbm93aWRjdGxwYXJcZmFhdXRvXHJpbjBcbGluMFxpdGFwMCBccnRsY2hcZmNzMSBcYWYyXGFmczI0XGFsYW5nMTAyNSBcbHRyY2hcZmNzMCANClxmMlxmczI0XGxhbmcxMDMzXGxhbmdmZTEwNDJcY2dyaWRcbGFuZ25wMTAzM1xsYW5nZmVucDEwNDIgXHNuZXh0MjAgKiBMZWZ0IEp1c3RpZmllZDt9fXtcKlxsYXRlbnRzdHlsZXNcbHNkc3RpbWF4MTU2XGxzZGxvY2tlZGRlZjB9e1wqXHJzaWR0YmwgXHJzaWQ2NDQ2OTkxXHJzaWQ4NTIwOTE5XHJzaWQxMDU1MjU0NX17XCpcZ2VuZXJhdG9yIE1pY3Jvc29mdCBXb3JkIDExLjAuNTYwNDt9e1xpbmZvDQp7XHRpdGxlIEZpcnN0IGxldmVsOiBPaWwgTGVha2FnZX17XGF1dGhvciBtYXJjdXMuYWx2ZXN9e1xvcGVyYXRvciBtYXJjdXMuYWx2ZXN9e1xjcmVhdGltXHlyMjAxNFxtbzJcZHkyMFxocjlcbWluMzF9e1xyZXZ0aW1ceXIyMDE0XG1vMlxkeTIwXGhyOVxtaW4zMX17XHZlcnNpb24xfXtcZWRtaW5zMH17XG5vZnBhZ2VzMX17XG5vZndvcmRzN317XG5vZmNoYXJzNDF9e1wqXGNvbXBhbnkgV2FiY299e1xub2ZjaGFyc3dzNDd9e1x2ZXJuMjQ2ODl9fQ0KXHBhcGVydzIwMTYwXHBhcGVyaDE3MjgwXG1hcmdsODUwXG1hcmdyODgyMlxtYXJndDE0MTdcbWFyZ2IxNDE3XGx0cnNlY3QgXGRlZnRhYjU2N1x3aWRvd2N0cmxcZnRuYmpcYWVuZGRvY1xoeXBoaG90ejQyNVx3cmFwdHJzcFxub3hsYXR0b3llblxleHBzaHJ0blxkbnRibG5zYmRiXG5vc3BhY2Vmb3J1bFxoeXBoY2FwczBcaG9yemRvY1xkZ2hzcGFjZTEyMFxkZ3ZzcGFjZTEyMFxkZ2hvcmlnaW4xNzAxXGRndm9yaWdpbjE5ODRcZGdoc2hvdzANClxkZ3ZzaG93M1xqY29tcHJlc3Ncdmlld2tpbmQ0XHZpZXdzY2FsZTEwMFxub2xuaHRhZGp0YmxccnNpZHJvb3QxMDU1MjU0NSBcZmV0MHtcKlx0ZW1wbGF0ZSBDOlxcRG9jdW1lbnRzIGFuZCBTZXR0aW5nc1xcbWFyY3VzLmFsdmVzXFxEYWRvcyBkZSBhcGxpY2F0aXZvc1xcTWljcm9zb2Z0XFxNb2RlbG9zXFxTQVBzY3JpcHRXb3JkVGVtcGxhdGUuZG90fXtcKlxkb2N2YXIge1RleHRDaGFuZ2VkfXtZfX1cbHRycGFyIFxzZWN0ZCBcbHRyc2VjdA0KXGxpbmV4MFxzZWN0ZGVmYXVsdGNsXHNmdG5iaiB7XCpccG5zZWNsdmwxXHBudWNybVxwbnFjXHBuc3RhcnQxXHBuaW5kZW50NzIwXHBuaGFuZyB7XHBudHh0YSAufX17XCpccG5zZWNsdmwyXHBudWNsdHJccG5xY1xwbnN0YXJ0MVxwbmluZGVudDcyMFxwbmhhbmcge1xwbnR4dGEgLn19e1wqXHBuc2VjbHZsM1xwbmRlY1xwbnFjXHBuc3RhcnQxXHBuaW5kZW50NzIwXHBuaGFuZyB7XHBudHh0YSAufX17XCpccG5zZWNsdmw0DQpccG5sY2x0clxwbnFjXHBuc3RhcnQxXHBuaW5kZW50NzIwXHBuaGFuZyB7XHBudHh0YSApfX17XCpccG5zZWNsdmw1XHBuZGVjXHBucWNccG5zdGFydDFccG5pbmRlbnQ3MjBccG5oYW5nIHtccG50eHRiICh9e1xwbnR4dGEgKX19e1wqXHBuc2VjbHZsNlxwbmxjbHRyXHBucWNccG5zdGFydDFccG5pbmRlbnQ3MjBccG5oYW5nIHtccG50eHRiICh9e1xwbnR4dGEgKX19e1wqXHBuc2VjbHZsNw0KXHBubGNybVxwbnFjXHBuc3RhcnQxXHBuaW5kZW50NzIwXHBuaGFuZyB7XHBudHh0YiAofXtccG50eHRhICl9fXtcKlxwbnNlY2x2bDhccG5sY2x0clxwbnFjXHBuc3RhcnQxXHBuaW5kZW50NzIwXHBuaGFuZyB7XHBudHh0YiAofXtccG50eHRhICl9fXtcKlxwbnNlY2x2bDlccG5sY3JtXHBucWNccG5zdGFydDFccG5pbmRlbnQ3MjBccG5oYW5nIHtccG50eHRiICh9e1xwbnR4dGEgKX19XHBhcmRccGxhaW4gXGx0cnBhcg0KXHMyMFxxbCBcbGkwXHJpMFxzbDI0MFxzbG11bHQwXG5vd2lkY3RscGFyXGZhYXV0b1xyaW4wXGxpbjBcaXRhcDAgXHJ0bGNoXGZjczEgXGFmMlxhZnMyNFxhbGFuZzEwMjUgXGx0cmNoXGZjczAgXGYyXGZzMjRcbGFuZzEwMzNcbGFuZ2ZlMTA0MlxjZ3JpZFxsYW5nbnAxMDMzXGxhbmdmZW5wMTA0MiB7XHJ0bGNoXGZjczEgXGFmMiBcbHRyY2hcZmNzMCBcbGFuZzEwNDZcbGFuZ2ZlMTA0MlxsYW5nbnAxMDQ2XGluc3JzaWQ2NDQ2OTkxIA0KRmlyc3QgbGV2ZWw6IE9pbCBMZWFrYWdlfXtccnRsY2hcZmNzMSBcYWYyIFxsdHJjaFxmY3MwIFxsYW5nMTA0NlxsYW5nZmUxMDQyXGxhbmducDEwNDZcaW5zcnNpZDEwNTUyNTQ1IA0KXHBhciB9e1xydGxjaFxmY3MxIFxhZjIgXGx0cmNoXGZjczAgXGxhbmcxMDQ2XGxhbmdmZTEwNDJcbGFuZ25wMTA0NlxpbnNyc2lkNjQ0Njk5MSBTZWNvbmQgbGV2ZWw6IFRlYXJkb3dufXtccnRsY2hcZmNzMSBcYWYyIFxsdHJjaFxmY3MwIFxsYW5nMTA0NlxsYW5nZmUxMDQyXGxhbmducDEwNDZcaW5zcnNpZDY0NDY5OTFcY2hhcnJzaWQ2NDQ2OTkxIA0KXHBhciB9"
session.findById("wnd[0]/tbar[0]/btn[3]").press
session.findById("wnd[0]/tbar[0]/btn[11]").press
session.findById("wnd[0]/sbar").doubleClick
All the variables that I need to change, according to the Excel Sheet are in the model: XXXXX-1~13
I just need to replace this variables to their according columns in my sheet, for example, XXXXX-1 = B2, XXXXX-2 = C2 etc.
How can I create a link between this scritp and my Excel Sheet?
Thxx!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.