Results 1 to 5 of 5
  1. #1
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    250
    Thanks
    3
    Thanked 1 Time in 1 Post

    Query SAP from Excel (XP)

    Does anyone have experience querying SAP from Excel?

    Someone here gave me a copy of the VB6 module they wrote to do this. I know that I cannot pull the code verbatim from VB6 to Excel. For example, I need the equivalent of the <font color=red>Me</font color=red> function in VB6 to use in XL. Most other things look fairly straightforward.

    I still need to get permissions setup to CreateObjects.

    Thanks as always,
    Alan

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query SAP from Excel (XP)

    This is something I have no practical experience with either; although I would expect that you will need to have an Oracle driver installed on your machine. (This may be a special install option on Excel XP.)

    Is it possible that you could save the module with a TXT extension and then post it as an attachment - in case there are other issues?
    Grüße

  3. #3
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    250
    Thanks
    3
    Thanked 1 Time in 1 Post

    Re: Query SAP from Excel (XP)

    <font face="Comic Sans MS">Soon as I get it written, I will post and we can all laugh at it together!</font face=comic>
    Alan

  4. #4
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query SAP from Excel (XP)

    Actually, I meant the VB6 module. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Grüße

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 18 Times in 18 Posts

    Re: Query SAP from Excel (XP)

    The "Me" will be the main form of the VB6 app. If you create a userform in Excel, with controls of the same name as those referenced in the VB6 module, you should be able to get somewhere. As unkamunka mentioned, you will need an Oracle ODBC driver, and access to the Oracle database behind SAP.

Posting Permissions

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