Sample Excel VBA code to extract from SAP Table

[Ivancdl]

Hello,

Does anyone have a sample code/documentation in Excel VBA to extract entries in a SAP table (Say KNA1), and feed back the entries to excel?

This will be very helpful.

Thank you very much!

Cheers!

IvanC

 

[JerrySmith123]

Go to

http://www.sappro.com/downloadFrame.html.

Drill into 2002. Look for the words "automation". You can download some stuff. Not much but it's something.

Here's something

http://www.tek-tips.com/gviewthread.cfm/lev2/78/lev3/80/pid/649/qid/456645

And something from the HELP files.. 45b...but it might work

http://help.sap.com/saphelp_45b/helpdata/de/59/ae41f0488f11d189490000e829fbbd/content.htm

 

[ralphwiggum]

Check out the book Professional VB SAP R/3 Programming. This book will help you extract data related to most any SAP objects as well as creating and modifying data through your VB and VBA applications. The mechanism that allows this is included on the SAP frontend installation CD. The component from the CD is called SAP DCOM Component Connector (or something like that). Hope this helps.