open link in hyperlink column with fire fox

[gach]

I have a worksheet with a column (A) using the HYPERLINK function to retrieve the URL in the column (D).

Each time I click a link on column (A), I would like to open it in Firefox (my NON DEFAULT browser).


Does anybody know how this can be done?

[buran]

try using shell, e.g.

Please Login or Register  to view this content.

[gach]

try using shell, e.g.

Please Login or Register  to view this content.

I don't know how this can be done. Also, please remember that I have a column (A) using the HYPERLINK function and I need to open each one in random mode.

[CK76]

Yes, use Shell. But I'd recommend putting in check to see if it exists in (x86) or in \Program Files\.

See module1 in attached (for some reason I can't post the code...).

As for launching and opening url in firefox when hyperlink is clicked... you will need to supply sample workbook. Code will change depending on what's actually in those cells (string, formula, value etc).

[gach]

I pasted you module code in my workbook but it doesn't open any link of column (A) in Firefox Instead, it opens all links on my default browser (chrome)


I also can't post any code here...

[gach]

I pasted you module code in my workbook but it doesn't open any link of column (A) in Firefox Instead, it opens all links on my default browser (chrome)


I also can't post any code here...

[AlphaFrog]

Instead of using the HYPERLINK fnction in column A, just use this formula
=D1
To display the hyperlink address from column D

Add this code to the worksheet's code module

• Right-click on the sheet tab
• Select View Code from the pop-up context menu
• Paste the code from below in the worksheet's code module

Please Login or Register  to view this content.

[buran]

Please Login or Register  to view this content.

I add Cancel = True to stop entering in edit mode. Apart from that - no need of hyperlink function, just the text open with FireFox

[gach]

not working... Should I change something on this if my excel (2007) is Portuguese?

[buran]

Change

C:\Program Files (x86)\Mozilla Firefox\firefox.exe

to the correct location of firefox. This is for 64-bit Win. Of course for versatility this could be done with code.

[gach]

the path is 100% correct. I'm also on 64-bit Win but not working...

[CK76]

For HyperLink formula you can adopt my code to use following.

Please Login or Register  to view this content.

Dir function is used in regular module to check for firefox.exe path.
See attached.

[buran]

See attached file. does it work? just double click the cell in column A

[gach]

See attached file. does it work? just double click the cell in column A

Yes, It works! Thanks!