so i have been creating links from the Urls for the reports.
but now they are too long.
is there another way to open the below url?
here is what i have been doing:
myurl = selection.Value
Selection.Cut Destination:=Selection.Offset(0, 1)
ActiveSheet.Hyperlinks.Add anchor:=Selection, Address:=myurl, _
TextToDisplay:="View Map"
and later when the user double-clicks the cell the google map opens.
these are from gps tracking devices.
is there another way to open the below url?
thanks.
http://maps.google.com/maps?f=d&sou...o:33.5524 -84.2512+(2m0ft 13:10 11249-500-913)
but now they are too long.
is there another way to open the below url?
here is what i have been doing:
myurl = selection.Value
Selection.Cut Destination:=Selection.Offset(0, 1)
ActiveSheet.Hyperlinks.Add anchor:=Selection, Address:=myurl, _
TextToDisplay:="View Map"
and later when the user double-clicks the cell the google map opens.
these are from gps tracking devices.
is there another way to open the below url?
thanks.
http://maps.google.com/maps?f=d&sou...o:33.5524 -84.2512+(2m0ft 13:10 11249-500-913)