Opening url in Firefox from Excel

[kingofaces]

This may be beyond what VBA is capable of in excel, but I figured it was worth a shot. Basically I have a list of full urls I have in a spreadsheet. I keep it as a sort of list of bookmarks instead of in Firefox so that I can easily click the url, go back to Excel, and enter info associated with that link. Problem is that when I click on the hyperlink in Excel, the website redirects me. However, if I just copy and paste the url directly into Firefox, it works perfectly fine.

I know VBA can be used to open Internet Explorer, but can the same be done with Firefox? More specifically I'd like to open a new tab at the url. It sounds like it might be borderline doable, but I have a little hope since it's pretty basic still. Any thoughts are appreciated. Thanks.

 

[Alias13]

You can use Shell. The command line parameters are at: http://kb.mozillazine.org/Command_line_arguments

There are several ways to play the Shell command as with any macro.

e.g.

Sub Test_OpenFireFoxNewTab()
  OpenInFireFoxNewTab "http://www.mrexcel.com/forum/excel-questions/"
End Sub

Sub OpenInFireFoxNewTab(url As String)
  Dim pathFireFox As String
  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, vbHide
End Sub

Thanks Kenneth! Plz help me! How to hidden firefox when code running! ( With IE i can use: IE.visble = fasle)! Thanks for your help!

 

[Kenneth Hobson]

It is not an object so it would not have a visible property. You can look at command line options but I don't see one offhand. https://developer.mozilla.org/en-US/docs/Mozilla/Command_Line_Options

 

[Alias13]

Thanks Kenneth!