Using MS Access to control SAP

[andyrew30]

Hi,

I am not sure if anyone will know much about this. But I've googled quite a few things and come up with nothing of much help. I am trying to write a code that will run through one of my tables and copy a value from that table and then open SAP and run a search of the value, then save an excel copy of the results of the search, and repeat for each value in the table.

I am not asking for the code for the entire thing, just the code to access SAP similar to the way you open up other applications like internet explorer.

Thanks!!

 

[JHB]

When i Google for "open sap using vba" a lot of hits pops up, with and without code!

 

[Uncle Gizmo]

Heres a link based on Open SAP using VBA