+ Reply to Thread
Results 1 to 8 of 8

Connection with SAP

  1. #1
    Registered User
    Join Date
    06-11-2008
    Posts
    6

    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.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202
    Have you contacted SAP, I think you are going to need some Excel/SQL code but I'm not sure what SAP uses for it's database engine.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good morning lazyboy

    It's a while since I used SAP, but I seem to remember that it ran on an SQL server. Try going to Data > Import External Data > New Database Query. Explore this dialog, and see if there's anything in there that looks SAP-ish that you can connect to. You might need to speak to your IT person / dept to find the right path.

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  4. #4
    Registered User
    Join Date
    06-11-2008
    Posts
    6
    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.

  5. #5
    Registered User
    Join Date
    06-11-2008
    Posts
    6
    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.
    Attached Images Attached Images

  6. #6
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    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

  7. #7
    Registered User
    Join Date
    06-11-2008
    Posts
    6
    Quote 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.

  8. #8
    Registered User
    Join Date
    06-11-2008
    Posts
    6

    For others as referrence

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1