Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web Queries : Passing variables via POST method not working
Hello !
This is my first post here, and hopefully not my last. Hope someone can help, I'm clueless. I have to pass a few variables to a VBA Web Query that uses POST method. So far, so good. However, one of the variables is a bit tricky (it's actually a constant), of the form "/wEWIALL337KBDgK+1+PfDwLhp" (but way longer). Excel wont pass it as is because of the + signs. When I check out the POST data sent with an http analyzer, I see that the pluses have become line returns ! Original : "/wEWIALL337KBDgK+1+PfDwLhp" Becomes : "/wEWIALL337KBDgK 1 PfDwLhp" I tried replacing the pluses by Chr(43), but the problem remains, the http analyzer still shows the variable passed with line returns, which of course, gives me an error page from the server. Any clues on a workaround (pretty pretty please) ? Thanks in advance. PS. I'm working on Excel 2002 SP3. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please post this thread a correct full method, method about | New Users to Excel | |||
Please post this thread a complete correct method, method about te | New Users to Excel | |||
Passing variables for range series charts, what to do with post macro run; unable to | Excel Programming | |||
Controlling ODBC queries with VB variables | Excel Programming | |||
Controlling ODBC queries with VB variables | Excel Programming |