gonen
09-26-2011, 10:48 PM
Hi
I have a long url like this:
http://maps.google.com/maps?saddr=40.515065,-74.377585(US_NJ,Edison%20-Comfort%20Inn%20)&daddr=40.310573,-74.663411(US_NJ,Princeton%20-AAA%20)+to:39.95278,-75.149188(US_PA,Philadelphia%20-Constitution%20Hall%20)+to:39.950399,-75.15047(US_PA,Philadelphia%20-Liberty%20Bell%20)+to:39.94564,-75.14072(US_PA,Philadelphia%20-Penn%20S%20Landing%20Park%20)+to:39.9649,-75.1802(US_PA,Philadelphia%20-Rocky%20Steps%20)+to:39.9524,-75.147335(US_PA,Philadelphia%20-The%20Mint%20)+to:39.282058,-76.612648(US_MD,Baltimore%20-Maryland%20Science%20Center%20Imax%20)+to:39.286715,-76.608406(US_MD,Baltimore%20-National%20Aquarium%20In%20Baltimore%20)+to:38.88354,-77.099561(US_VA,Arlington%20-Highlander%20Motel%20)&view=map&hl=en (http://maps.google.com/maps?saddr=40.515065,-74.377585%28US_NJ,Edison%20-Comfort%20Inn%20%29&daddr=40.310573,-74.663411%28US_NJ,Princeton%20-AAA%20%29+to:39.95278,-75.149188%28US_PA,Philadelphia%20-Constitution%20Hall%20%29+to:39.950399,-75.15047%28US_PA,Philadelphia%20-Liberty%20Bell%20%29+to:39.94564,-75.14072%28US_PA,Philadelphia%20-Penn%20S%20Landing%20Park%20%29+to:39.9649,-75.1802%28US_PA,Philadelphia%20-Rocky%20Steps%20%29+to:39.9524,-75.147335%28US_PA,Philadelphia%20-The%20Mint%20%29+to:39.282058,-76.612648%28US_MD,Baltimore%20-Maryland%20Science%20Center%20Imax%20%29+to:39.286715,-76.608406%28US_MD,Baltimore%20-National%20Aquarium%20In%20Baltimore%20%29+to:38.88354,-77.099561%28US_VA,Arlington%20-Highlander%20Motel%20%29&view=map&hl=en)
I need to assign hyperlink (using VBA code) in a cell to this url but found out that the url is too long...
I tried to place the url in a cell and
ActiveCell.FormulaR1C1 = "=HYPERLINK(RC26,""Day Route"")"
or
split the url into few cells and hyperlink with
=HYPERLINK(CONCATENATE(Z5,AA5))
both not worked.
can someone help on this ?
thank you !!!
I have a long url like this:
http://maps.google.com/maps?saddr=40.515065,-74.377585(US_NJ,Edison%20-Comfort%20Inn%20)&daddr=40.310573,-74.663411(US_NJ,Princeton%20-AAA%20)+to:39.95278,-75.149188(US_PA,Philadelphia%20-Constitution%20Hall%20)+to:39.950399,-75.15047(US_PA,Philadelphia%20-Liberty%20Bell%20)+to:39.94564,-75.14072(US_PA,Philadelphia%20-Penn%20S%20Landing%20Park%20)+to:39.9649,-75.1802(US_PA,Philadelphia%20-Rocky%20Steps%20)+to:39.9524,-75.147335(US_PA,Philadelphia%20-The%20Mint%20)+to:39.282058,-76.612648(US_MD,Baltimore%20-Maryland%20Science%20Center%20Imax%20)+to:39.286715,-76.608406(US_MD,Baltimore%20-National%20Aquarium%20In%20Baltimore%20)+to:38.88354,-77.099561(US_VA,Arlington%20-Highlander%20Motel%20)&view=map&hl=en (http://maps.google.com/maps?saddr=40.515065,-74.377585%28US_NJ,Edison%20-Comfort%20Inn%20%29&daddr=40.310573,-74.663411%28US_NJ,Princeton%20-AAA%20%29+to:39.95278,-75.149188%28US_PA,Philadelphia%20-Constitution%20Hall%20%29+to:39.950399,-75.15047%28US_PA,Philadelphia%20-Liberty%20Bell%20%29+to:39.94564,-75.14072%28US_PA,Philadelphia%20-Penn%20S%20Landing%20Park%20%29+to:39.9649,-75.1802%28US_PA,Philadelphia%20-Rocky%20Steps%20%29+to:39.9524,-75.147335%28US_PA,Philadelphia%20-The%20Mint%20%29+to:39.282058,-76.612648%28US_MD,Baltimore%20-Maryland%20Science%20Center%20Imax%20%29+to:39.286715,-76.608406%28US_MD,Baltimore%20-National%20Aquarium%20In%20Baltimore%20%29+to:38.88354,-77.099561%28US_VA,Arlington%20-Highlander%20Motel%20%29&view=map&hl=en)
I need to assign hyperlink (using VBA code) in a cell to this url but found out that the url is too long...
I tried to place the url in a cell and
ActiveCell.FormulaR1C1 = "=HYPERLINK(RC26,""Day Route"")"
or
split the url into few cells and hyperlink with
=HYPERLINK(CONCATENATE(Z5,AA5))
both not worked.
can someone help on this ?
thank you !!!