mardi 27 novembre 2018

How do i click on a button in my Firefox browser using VBA?

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