ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Web Query Parameters (https://www.excelbanter.com/excel-programming/287373-web-query-parameters.html)

raboo2u

Web Query Parameters
 
I am trying to query a web page that has dropdown boxes. There are
boxes that I want filled in. All others it doesn't matter if they ar
filled in. The fields a

Timestamp
Division
Department
Queue Group
Owner
Queue

For the timestamp I want the closest time to 00:00 on todays date. Fo
Department I want a specific entry for instance General Support.

I need to know how to create the parameters for this after the ? at th
end of the http:// link.

Can anyone help

--
Message posted from http://www.ExcelForum.com


raboo2u[_2_]

Web Query Parameters
 
I forgot to add the timestamp format is:

09 Jan 04 00:0

--
Message posted from http://www.ExcelForum.com


Don Guillett[_4_]

Web Query Parameters
 
Post (copy/paste here) your link and the details along with your macro if
you are using one.

--
Don Guillett
SalesAid Software

"raboo2u " wrote in message
...
I am trying to query a web page that has dropdown boxes. There are 2
boxes that I want filled in. All others it doesn't matter if they are
filled in. The fields a

Timestamp
Division
Department
Queue Group
Owner
Queue

For the timestamp I want the closest time to 00:00 on todays date. For
Department I want a specific entry for instance General Support.

I need to know how to create the parameters for this after the ? at the
end of the http:// link.

Can anyone help?


---
Message posted from
http://www.ExcelForum.com/




raboo2u[_3_]

Web Query Parameters
 
I just found out that the form I am trying to pass parameters to is a
"Post" not a "Get". So the parameters will not pass through. I
appreciate the help though.


---
Message posted from http://www.ExcelForum.com/


Jake Marx[_3_]

Web Query Parameters
 
Hi raboo2u,

You can do this, although it involves more VBA. Do a search on
groups.google.com for "Jake Marx", POST, and InternetExplorer, and you'll
see some examples of how to do it.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


I just found out that the form I am trying to pass parameters to is a
"Post" not a "Get". So the parameters will not pass through. I
appreciate the help though.


---
Message posted from http://www.ExcelForum.com/




All times are GMT +1. The time now is 09:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com