Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

VL31N Macro creation

former_member999950
Discoverer

‎2023 Jul 13 9:16 PM

0 Kudos
337

Good day,

I'm trying to create an Excel VBA macro for VL31N to allow cell data entry to overwrite the code in the inbound delivery at the click of a button. I am able to scrip, record and playback in ECC. However, when pasting the code in Excel I do not know what to put to get the code to function properly.

Does a macro already exist for this tcode where sample Excel VBA coding is used to help? I've exhausted my google search and don't have the coding expertise to put 2 and 2 together.

Thanks

2 REPLIES 2

Ulrich_Schmidt
Product and Topic Expert
Product and Topic Expert

‎2023 Jul 13 10:56 PM

253

Hi Dave,

it is not completely clear to me, what you are doing. Are you trying to call the OCX controls (like wdtfuncs.ocx etc.) that come with SAPGui, from you Excel macro? An alternative might be to use VB.NET and then use the .NET Connector (SAP NCo) for the interaction with the ECC. But this would require that there are some BAPIs/RFMs which do what you need, because it is not possible to execute a tcode via RFC.

Anyway, a few more details about which tools/libraries you currently use, and how far you got would help.

Regards, Ulrich

Sandra_Rossi
Active Contributor

‎2023 Jul 14 11:52 AM

0 Kudos
253

NB: there are several options to script SAP GUI, but I guess you are talking about SAP GUI Scripting.