ByDesign Excel Add-in - Login and Save data to with VBA

[former_member669169]

I'm wondering if it's possible to automate logging in and using the 'save data to' button through vba on the ByDesign add-in. I'm trying to automate sales orders from customers.

[former_member842544]

Hi Jordy,

Did you get an answer / solution?

[moshenaveh]

While we're happy that you've come to SAP Community to get an answer to your question, you posted your question as a comment in an old thread.

If you're looking for help, you should ask a new question: https://answers.sap.com/questions/ask.html.

Here are some tips to help you craft an effective question for our community: https://community.sap.com/resources/questions-and-answers, https://developers.sap.com/tutorials/community-qa.html, https://groups.community.sap.com/t5/welcome-corner-discussions/advice-from-sap-champions-questions-a....

I encourage you to follow this guidance, as I'd really like to see you get a solution to your problem.

I hope you find this advice useful!

[docly]

Gibt es noch keine Lösung?

Ich suche fast dasselbe. Ich möchte, dass in einem Excel eingebundene ByDesign Reports automatisch aktualisiert werden, dazu muss sich aber nach dem Öffnen erst ein User anmelden.

Kann man die Anmeldung mit VBA o.ä. automatisieren (Makros mit Aktionen im SAP Add-in werden nicht aufgezeichnet)?

Es soll letztlich erreicht werden, dass das Excel von einem cronjob geöffnet wird, alle SAP Reports aktualisiert werden und es wieder geschlossen wird.

LG Markus

[Anantpatel]

Hi jdom,

Can you brief more ?

Regards,

anant

[former_member669169]

Absolutely, Anant.

With the ByDesign Excel Add-in there is a button that needs to be clicked to Logon. When clicked a popup comes up and you need to enter the SAP System URL, User Name, and Password to then click Log On. I'm trying to write a script in VBA to avoid having to go through the Log On process every time and be able to automate it.

I'd also like to be able to automate the use of the 'Save Data to' button. If I can find a way to do both of these actions in VBA, i'll be able to automate the process of opening the sheet, logging in and uploading it to SAP ByDesign with Python.