Click here to Skip to main content
15,896,063 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi all,

I have crated excel with
XML
Hyperlink 
function. here I have open my web site with query string. it's working fine.

but more than 170 characters it's not accepting The Link is changing
XML
#Value
formate.

is there any limitation of character for querystring? If not how can I pass bulk of text through query string.

let me know?

my code is;

XML
=HYPERLINK("http://example.com/Default.aspx?order="&A3&"&firstname="&B3&"&lastname="&C3&"&custom="&D3&"&custom2="&E3,"Link")



Thanks.
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900