+ Reply to Thread
Results 1 to 9 of 9

VBA vs SAP

  1. #1
    Registered User
    Join Date
    07-26-2012
    Location
    Slovakia
    MS-Off Ver
    2013
    Posts
    25

    VBA vs SAP

    hi all,

    i have hopefully a simple question for you.

    I am logged into sap and want to write a vba code, that will run a new function in sap under my current login (it means with no need of any password or username...).

    Is it possible?

    Thank you

  2. #2
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: VBA vs SAP

    SAP! You mean the accounting system?

  3. #3
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,213

    Re: VBA vs SAP

    xposted: http://www.ozgrid.com/forum/showthread.php?t=171224 and http://www.mrexcel.com/forum/excel-q...ns-vs-sap.html

  4. #4
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: VBA vs SAP

    Kyle,
    If the OP is refferirng to an accounting system, this will signifay a big shift for users of excel. I never thought you could VBA in any accounting application.

  5. #5
    Registered User
    Join Date
    07-26-2012
    Location
    Slovakia
    MS-Off Ver
    2013
    Posts
    25

    Re: VBA vs SAP

    Yes i mean accounting system.

  6. #6
    Registered User
    Join Date
    07-26-2012
    Location
    Slovakia
    MS-Off Ver
    2013
    Posts
    25

    Re: VBA vs SAP

    AB33,

    yes you can connect SAP with VBA.
    I have one code, that should work, but what does not suits me is that this code start SAP logon:
    Please Login or Register  to view this content.
    Last edited by JosephP; 10-26-2012 at 06:17 AM. Reason: code tags

  7. #7
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: VBA vs SAP

    Okay! I hope Kyle will correct me if I am wrong.

    Please Login or Register  to view this content.
    You are not writing VBA on SAP, but referencing it, like any other applications, such as word, excel and outlook. Am I right?

  8. #8
    Registered User
    Join Date
    07-26-2012
    Location
    Slovakia
    MS-Off Ver
    2013
    Posts
    25

    Re: VBA vs SAP

    Yes you are right. I just want the excel to run function in SAP (when iam already logged in, with current connection), not create a new connection.

  9. #9
    Registered User
    Join Date
    07-26-2012
    Location
    Slovakia
    MS-Off Ver
    2013
    Posts
    25

    Re: VBA vs SAP

    Hi all guys,

    i have already solved this issue, code is so simple, check maybe it will help someone else:
    Please Login or Register  to view this content.
    Last edited by JosephP; 10-26-2012 at 06:18 AM. Reason: code tags

+ 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