excel web queries: make the box for the website name much longer

[susannah]

excel web queries: make the box for the website name much longer;
we need to be able to type in a webaddress that is long: the host name, the
cgi, the program name, password and userid, and a bunch of parameters for the
program. Excel says, when we try to edit our query, that the address is too
long to edit; please make it longer. i can save the .iqy and edit it that
way, but that's too hard for my end users. they need to be able to edit the
page name right in the box under Edit Query.
thanks.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...0003d12&dg=microsoft.public.excel.programming

 

[Don Guillett]

I would suggest that you record a macro while doing a simple change to the
typed in url and then modify the resulting url in the macro for variables in
your worksheet.
this one happened to be for Morningstar.com

"URL;http://yourwebsite.com/Stock/Income10.asp?Country=USA&Symbol=ibm&stocktab=finance"
"URL;http://" & [a1] &
".com/Stock/Income10.asp?Country=USA&Symbol=ibm&stocktab=finance"
where cell a1 would have had type in Morningstar.com