Nasty 400 when running web query macro

Hello everyone.

I'm suspicious that I've found a limitation in excel with regards to making GET Requests across the web.

I am using Excel 2000. My web query is written manually and has the following attributes:

With ActiveSheet.QueryTables.Add(Connection:= _
"URL;" & URL, Destination:=Cells(i, c_bosmessages))
.Name = "hello"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = True
.SaveData = False
.AdjustColumnWidth = True
.RefreshPeriod = 0
.WebSelectionType = xlAllTables
.WebFormatting = xlWebFormattingNone
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.Refresh BackgroundQuery:=False
End With


Higher up in my code, the URL variable gets built as such:

URL = "http://ada.netwolves.com/test.php?type=INSERT&"

'General Info
URL = URL & "c_oid=[work_order%5Eorder_category_id%5E" & Cells(i, c_oid).Value & "]&"

Anyway, I keep getting a nasty 400 each time I try to run this web query. Any ideas?

-Matt

it appears that this is due to the square brackets that I had in my querystring. Whatever library is used to facilitate the HTTP GET Request didn't like those.