Hi Annet,

I'm not very familiar with SAP. I would suggest you do a google search on
"Automate" and "SAP" and "vb" to get more information. I did this and found
the following site, which has some more info:

http://www.sapgenie.com/interfaces/

It looks like there are quite a few third-party solutions that may work for
you. You may also want to post to an SAP newsgroup if you can find one....

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Thanks for your reactions.

The AppActivate command could be an option, but I'm afraid that's
still not fully safe.

I would like to make a macro that controls SAP and performs all the
actions, but I'm not sure how. I have done something similar with
another application (Reflection), but that was much easier, because
Reflection had a recorder built in.
I can see in the menu that SAP has options like 'Report', 'Utilities',
'Jobs', so I guess SAP may have a recorder, but since I'm not
authorized to perform those transactions, that's not very helpful.
Getting authorization is probably a Mission Impossible, because
management believes that we should use SAP instead of Excel and they
won't support my attempts to get our IT-department to help me,
although I myself and my colleagues are convinced that Excel is a
better tool for making Graphs etc.

I have a feeling I should use CreateObject and I think I need some
library, but I really can't find out where to find it. How can I find
out what I need and where can I find it? Or should I use something
else? I have some knowledge of using ODBC, but in this case, that's
not an option. I know very little of DAO, OLE, ActiveX.
Can anyone help me? Or maybe give a hint as to what direction I should
go? Preferably with examples? Please???

TIA again,

Annet


---
Message posted from http://www.ExcelForum.com/