I need to programatically pull down a web page with a URL that
includes brackets. Excel *thinks* I want to be prompted to enter
paramenters. How can I disable the parameters and/or escape the
brackets if they need to be included in the webquery link.

I did try encoding the brackets to %5 for [ and B% for ] but I still
get prompted to enter parameter values.

Here is an example URL with brackets:
http://forecast.weather.gov/MapClick.php?w0[]5D=t&Submit=Submit&FcstType=digital&textField1=44. 9477&textField2=-93.1037&site=mpx

Thanks.

Hi

(1) Try breaking up the http string like http://domain.com" & "[]" &
"otherstuff"

(2) You might try to use a single quote delimiter '

Hope it helps
--
DownThePaint
Where points are scored and games are won!


" wrote:

I need to programatically pull down a web page with a URL that
includes brackets. Excel *thinks* I want to be prompted to enter
paramenters. How can I disable the parameters and/or escape the
brackets if they need to be included in the webquery link.

I did try encoding the brackets to %5 for [ and B% for ] but I still
get prompted to enter parameter values.

Here is an example URL with brackets:
http://forecast.weather.gov/MapClick.php?w0[]5D=t&Submit=Submit&FcstType=digital&textField1=44. 9477&textField2=-93.1037&site=mpx

Thanks.

If you remove those offending brackets from the URL, you still get the same
data, but with additional weather info.

NickHK

wrote in message
oups.com...
I need to programatically pull down a web page with a URL that
includes brackets. Excel *thinks* I want to be prompted to enter
paramenters. How can I disable the parameters and/or escape the
brackets if they need to be included in the webquery link.

I did try encoding the brackets to %5 for [ and B% for ] but I still
get prompted to enter parameter values.

Here is an example URL with brackets:

http://forecast.weather.gov/MapClick.php?w0[]5D=t&Submit=Submit&FcstType=digital&textField1=44. 9477&textField2=-93.1037&site=mpx

Thanks.