Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with FollowHyperlink and Firefox
This macro takes active cell value and adds to a link and then opens
it in the default browser, it works fine with IE. But with Firefox the link becomes, "http://www.rcdb.com/qs.htm? quicksearch=JetlineFirefoxHTML\Shell\Open\Command" . Sub rcdb_check() Dim RCDBCLINK As String RCDBCLINK = "http://www.rcdb.com/qs.htm?quicksearch=" & ActiveCell.Value ActiveWorkbook.FollowHyperlink Address:=RCDBCLINK, NewWindow:=True End Sub Does anybody have a solution for this or a alternative code? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with FollowHyperlink and Firefox
This works for me with FireFox (and Opera for that matter).
Private Sub CommandButton1_Click() Const HLINKBASE As String = "http://www.rcdb.com/qs1.htm?quicksearch=" Range("A1").Value = "Kingda Ka" ActiveWorkbook.FollowHyperlink Address:=HLINKBASE & Range("A1").Value, NewWindow:=True End Sub NickHK wrote in message oups.com... This macro takes active cell value and adds to a link and then opens it in the default browser, it works fine with IE. But with Firefox the link becomes, "http://www.rcdb.com/qs.htm? quicksearch=JetlineFirefoxHTML\Shell\Open\Command" . Sub rcdb_check() Dim RCDBCLINK As String RCDBCLINK = "http://www.rcdb.com/qs.htm?quicksearch=" & ActiveCell.Value ActiveWorkbook.FollowHyperlink Address:=RCDBCLINK, NewWindow:=True End Sub Does anybody have a solution for this or a alternative code? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with FollowHyperlink and Firefox
Seems to be some problem with FireFox portable installation, mine and
your code worked fine on a another computer. Thanx! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with FollowHyperlink and Firefox
Just tried it with it the portable version and still works fine.
Sure it not case of the ActiveCell.Value not being waht you expect ? NickHK wrote in message ps.com... Seems to be some problem with FireFox portable installation, mine and your code worked fine on a another computer. Thanx! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i save a file as htm that can be read by Firefox? | Excel Discussion (Misc queries) | |||
Make Excel use Firefox | Excel Programming | |||
Embedding Excel in IE and Firefox | Excel Programming | |||
control mozilla firefox | Excel Programming | |||
Web Import via Firefox | Excel Programming |