errors when accessing SAP from Visual Basic (in Excel)

Question: Hello,

I am learning how to access SAP 4.6C from office applications. As an example, I am trying to call a BAPI from Excel 2000. I have found plenty of documentation that contains simple code samples. Many of them use the instruction:
Set functionCtrl = CreateObject("SAP.Functions")

From the documentation, it seems that you can use this instruction right away, but I get an error. I would like to know if there is some prerequisite (DLL, application) that is needed, as I have not found any comment on this.

As an alternative, I have skipped the previous code and tried:
Set oBAPICtrl = CreateObject("SAP.BAPI.1")

But then I get an error "Out of memory".

I would be really grateful if someone could help me with this.
Thank you
_________________
ilsap

Answer:
Look there, maybe it helps.

/forums/viewtopic.php?t=139430&highlight=

Answer:
Ok, thank you very much for your help
_________________
ilsap
Copyright ?2007 - 2008 www.jt77.com