The answer is Yes. You can do it provided you can control SAP using only
the keyboard.

However It does depend on knowing the exact key sequence you will be using
when you write the code. It breaks easily if, for example, SAP changes the
menu structure.

I would prefer to use OLE if that is available.

If the interaction is not trivial I would probably be looking at an external
tool like VB or a scripting language to control both Excel and SAP with
internal macros in both to produce the info required.

To find out more about Sendkeys type the word Sendkeys into the help  box in
the VBE.