How to enter a long address to new web query
 

sup pros
something like this
http://tinyurl.com/e2n5e
when i paste it , i get the message:-
The text string you entered is too long. Reduce the number of
characters used or cancel the entry


--
Pivotrend
------------------------------------------------------------------------
Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062
View this thread: http://www.excelforum.com/showthread...hreadid=400401

You should be able to get rid of http://
Unless you are still using IE2 or 3

"Pivotrend" wrote:


sup pros
something like this
http://tinyurl.com/e2n5e
when i paste it , i get the message:-
The text string you entered is too long. Reduce the number of
characters used or cancel the entry


--
Pivotrend
------------------------------------------------------------------------
Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062
View this thread: http://www.excelforum.com/showthread...hreadid=400401

i got rid of http://
still not working
there must be away folks
peterson you there!!! :(


--
Pivotrend
------------------------------------------------------------------------
Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062
View this thread: http://www.excelforum.com/showthread...hreadid=400401

i got rid of http://
still not working
there must be away folks


--
Pivotrend
------------------------------------------------------------------------
Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062
View this thread: http://www.excelforum.com/showthread...hreadid=400401

Did you try using tinyurl software to shorten the long url
http://tinyurl.com/


Pivotrend wrote in
message ...

i got rid of http://
still not working
there must be away folks


--
Pivotrend
------------------------------------------------------------------------
Pivotrend's Profile:
http://www.excelforum.com/member.php...fo&userid=4062
View this thread: http://www.excelforum.com/showthread...hreadid=400401

this opened it in a separate browser
i want to open that url in web query itself


--
Pivotrend
------------------------------------------------------------------------
Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062
View this thread: http://www.excelforum.com/showthread...hreadid=400401