SAP Data Transfer to Excel using Transaction Code
I am trying to retrieve data from a transaction code in SAP using VBA in MS Excel. I understand that there is one way of doing this using SAP GUI scripting but is there another way using Remote Function Calls?
I was looking at RFC_CALL_TRANSACTION and RFC_CALL_TRANSACTION_USING. Does this accomplish what I need? For example, I have a transaction code called "TCODE" and I need to pass some arguments in such as a date range to generate data. Can I use RFC's or should I stick to GUI scripting?
So far, I can connect to SAP and retrieve specific table information but how can I execute a transaction code while passing in parameters.
Set obSAPFnCntrl = CreateObject("SAP.Functions")
Set obSAPConn = obSAPFnCntrl.Connection
.System = "system"
.User = "user"
.Password = ""
.Language = "EN"
.Client = 750
Set obSAPFnUserDetail = obSAPFnCntrl.Add("RFC_CALL_TRANSACTION")
'Set obSAPFnUserDetail = obSAPFnCntrl.Add("BAPI_USER_GET_DETAIL")
Thanks in advance!