Sample VB code to call SAP BAPI from Excel

[Former Member]

Hi everyone, can someone PLEASE give me a sample VB code to call a BAPI in Excel. I need to map certain fields to specific cells.

thanks so much

Brian

[Former Member]

Hi Brian,

what do you use in order to connect to SAP, are you using the .NET Connector or Web Services? Check out the Office Business Application Starter Kit: Integrating 2007 Office System with SAP Using VSTO 2005 SE on http://msdn2.microsoft.com/en-us/library/bb498189.aspx, it's written in C# using VSTO but it gives an good overview of how to connect to SAP from Excel using Web Services.

- Juergen

[Former Member]

Hi Juergen: I was trying to use Excel, but i cant seem to stay connected.

I am not really a developer but I am trying to see if this works.

thanks

Brian