Skip to Content
avatar image
Former Member

Create SAP Session in specifc transaction from Excel

This was originally posted in the Scripting Languages Forum but did not get an answer.

I need to provide a logon box for SAP and then call a specific transaction from an Excel macro. I've found some of the answers here, but not enough to submit code for your analysis.

I can connect and run an RFC, however this project also requires user intervention/approval within SAP to continue.

Could someone please point me in the right direction.

Thanks

Bob

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Sep 13, 2007 at 10:09 PM

    Hi Bob,

    which version of Excel you are using? It might be a solution using Visual Studio Tools for Office in case you are running on Office 2007 and develop a VSTO App instead of using an Excel Macro. In this case you can open up the logon box the first time the user calls SAP, all further calls will be done using the provided credentials as long as the Excel App is open.

    - Juergen

    Add comment
    10|10000 characters needed characters exceeded