Paristocrate
asked on
Using Firefox in VBA Excel
Good Morning,
I'm trying to have a task automated using IE8 and Excel. But it appears that the only browser that would be available to users is Firefox. So, on the code below, I would like to have IE replaced by firefox. I Would greatly appreciate if I could get help with that. Thank you!
I'm trying to have a task automated using IE8 and Excel. But it appears that the only browser that would be available to users is Firefox. So, on the code below, I would like to have IE replaced by firefox. I Would greatly appreciate if I could get help with that. Thank you!
Sub Reporting()
'declaring Variable'
Dim IE As New InternetExplorer
'Dim IE As Object'
Dim IEDoc As HTMLDocument
Dim Input_Username As HTMLInputElement
Dim Input_Password As HTMLInputElement
Dim Input_Button As HTMLInputElement
Dim lien As HTMLLinkElement
Dim Advs As Object
Dim sear As Object
Dim TextA As Object
Dim Elementtab2 As Object
Dim BarName As String
'Loading the page'
IE.navigate "http://www.bmc.com/"
'Affichage de la fenetre IE'
IE.Visible = True
'Wait for the page to load'
wait_Nav IE
BarName = IE.LocationName
If BarName <> "BMC Extranet - Login" Then
GoTo SkipLoging:
Else
End If
'Filling out the log in form'
Set Input_Username = IE.document.all("username")
Input_Username.Value = "xxxxxxxx"
'On pointe et on remplit la zone de texte password'
Set Input_Password = IE.document.all("password")
Input_Password.Value = "xxxxxxxxx"
'Sign in'
Set Elementtab2 = IE.document.getElementsByTagName("INPUT")
For Each tble2 In Elementtab2
If tble2.Value = "Login" Then
tble2.Click
Exit For
End If
Next tble2
End Sub
Sub wait_Nav(IE As InternetExplorer)
Do While IE.readyState <> READYSTATE_COMPLETE Or IE.Busy
DoEvents
Loop
End Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER