double click cell , copy paste to IE , run ....for long url more than 350 characters

[raj soni]

hello friends ,

i have around 600 links in row A

and each one of them are 350 to 375 long in characters.....

when i click on any one of link , excel shows no progress , no errors , no message no pop ups from IE ...doesn't open in internet explorer

but when i click www google com , its open smoothly in internet explorer ...

i dont wish to open them from vba , instead opening them by clicking on them .

searched everywhere , tried everything ...but not helping ,

================================================================

So figured out another way around if we can create vba ....for DOUBLE CLICK

1 ) we double click on any of this 600 links ....basically we double click on any cell.
2 ) its copies and pastes 350 characters itself in internet explorer address bar.
3 ) and it gives " go " or "run " that value itself ......here value is offcourse url ...

i find this other way around solution for such problem .

[Norie]

If you don't want to use VBA how.are you going to be able to use BeforeDoubleClick?

[raj soni]

sir ,
i mean to say ,
i dont want to mention 350 to 370 long character url in inside vba ....
if something like we reference a1 = ....... , a2........so on....

i want to use vba for double clicking and opening them in IE .
but dont to open them from inside VBA...

i have 600 urls .......

[Norie]

You should be able to extract the URL from the cell that's been double clicked.

Then you could use ThisWorbook.FollowHyperlink, no need to have code to open IE and copy and paste to the address bar.