Connection with SAP

Guys,
Good day to all!
I have some inquiry to ask.
Well, my boss is asking me to make a vba in excel connecting with SAP, my problem is that we don't have an access to the database physically. Do you have some magic tricks or codes to help me.
I don't even have an idea how SAP operates, and they were asking me for a limited resources because even themselves don't know how to do it and they cannot even give me the requirements that I want.

DominicB and RoyUK, thanks for your replies.
Actually I was hired because of this through a third party IT Company which I am employed with. I have no idea of the project and this suprises me.
They actually want me to re-engineer an excel tool done by two person in UK to make their work easier (meaning bulk). As I examine the existing tool, I found out that it has an Add-In and unfortunately that Add-In is not included on the package that the guys from UK gave them. I asked for it but those guys from UK told me that these guys from this team insisted for a couple of tool which they told them that it wouldn't be possible if we use it here in the Phil. and in fact they (UK) also told me that the recreation of the tool is difficult. The in-house developers here also turned them down that's why I am here. I really hate to down this guys but I also want to examine this first before anything else 'coz it will become my problem in the future.
Anyway, Thanks for the replies and will update this thread as soon as I have another idea to come up with.

DominicB,
I have check the procedure that you have told me. Don't have SAP - ish on the box.

See the attachment for further reference. TIA.

Originally Posted by dominicb

Hi lazyboy

Can you connect to SAP by using a different database? The reason I ask is that here, we use Microsoft Dynamics NAV, and rather than allow the users to connect direct using Excel queries, IT have blocked that but have set up a number of server views using Crystal Reports. It is these server views that Excel can connect to and retrieve information from.

Alternately from that have you tried posting this question on one of the SAP forums?

Sorry I can't be of any more help.

DominicB

Thanks for the response sir,
Already got an idea how will I work with this. I only need a Sap Scripting tool to record (just like an excel macro) and then transfer the VB Script to excel vba. Will find a SAP forum. Thanks a lot.

Hi guys!
I just found out how to connect to SAP GUI using excel VBA integrating VBS.

Here is the sample:
with Option Explicit OFF

Please Login or Register  to view this content.

Excelente chico perezoso.
Solo falto un detalle:
en:
Set Connection = SAP_applic.openconnection(SAPBox)
SAPBox = "aqui va el nombre de la casilla que quieres abrir, solo es texto"

lo demás perfecto, solo que como agrego el usuario y contraseña?