I am able to go to the particular web page using VBA. Need to know how to click on the download button!! This is the code I am using -
Sub OpenInFireFoxNewTab() '(url As String) Dim pathFireFox As String Dim url As String url = "https://web page URL" pathFireFox = "C:\Program Files (x86)\Mozilla Firefox\firefox.exe" If Dir(pathFireFox) = "" Then pathFireFox = "C:\Program Files\Mozilla Firefox\firefox.exe" If Dir(pathFireFox) = "" Then MsgBox "FireFox Path Not Found", vbCritical, "Macro Ending" Exit Sub End If Shell """" & pathFireFox & """" & " -new-tab " & url End Sub
Aucun commentaire:
Enregistrer un commentaire