How to pull data from SAP into excel using VBA

former_member1364050 — Fri, 09 Dec 2022 20:17:00 GMT

My colleague and I are trying to pull data from SAP into excel using VBA to automate the process. He has a script that is able to successfully perform the task, but when I run it on my computer it falls out at the line shown below. The portion of the script shown is meant to automatically log the user onto the correct client server of SAP and then find the relevant data.

Any help would be appreciated, thanks.

Re: How to pull data from SAP into excel using VBA

Former Member — Fri, 09 Dec 2022 20:17:11 GMT

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with: https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members.

For example, you can:

- outline what steps you took to find answers (and why they weren't helpful)

- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags

- use a more descriptive subject line

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html

Questions on how to draw responses from members? Check out this discussion on how to improve questions. https://groups.community.sap.com/t5/welcome-corner-discussions/advice-from-sap-champions-questions-and-answers/m-p/123609/thread-id/1094

Question Re: How to pull data from SAP into excel using VBA in Technology Q&A

How to pull data from SAP into excel using VBA

Re: How to pull data from SAP into excel using VBA