Hi, I am tryig to dwnload at least one thng from SAP. The code I am using to connect you can see below. The target is to download something to excel workbook from MM03, for instance weight or base uint of measure for the materil number 1234567. I need support. Dim Logon As Object 'Logon control Dim R3conn As Object Set Logon = CreateObject("SAP.LogonControl.1") 'Create ActiveX object Set R3conn = Logon.NewConnection If R3conn.Logon(0, False) <> True Then 'Try Logon MsgBox "Cannot log on toSAP" End If

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Connect to SAP from excel and download one one parameter (weight)

Thread starter thedogg
Start date Aug 1, 2019
Tags

connect logon object r3conn set

thedogg

Board Regular

Aug 1, 2019

Hi,

I am tryig to dwnload at least one thng from SAP. The code I am using to connect you can see below. The target is to download something to excel workbook from MM03, for instance weight or base uint of measure for the materil number 1234567. I need support.

Code:

   Dim Logon As Object 'Logon control
   Dim R3conn As Object
   Set Logon = CreateObject("SAP.LogonControl.1") 'Create ActiveX object
   Set R3conn = Logon.NewConnection
   
   
   
   If R3conn.Logon(0, False) <> True Then 'Try Logon
              MsgBox "Cannot log on toSAP"      
   End If