PDA

View Full Version : Excel VBA opening SAP from Chrome



kezs
05-14-2020, 07:34 AM
Dear All,


Could you please help me how I could open SAP from VBA?
I have part of the code done:

Sub OpenSAP()

Dim ChromePath As String

ChromePath = """C:\Program Files (x86)\Google\Chrome\Application\chrome.exe"""

Shell (ChromePath & " -url https:// (https://ge.ent.box.com/folder/95662069581)website")

End Sub

This opens the website. I would need the VBA to click 2 buttons to get SAP opened.

I also would like to upload xlsb files to a Dropbox. I would highly appreciate if you could help me with its coding in VBA.

Many thanks! Ágnes