Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web Query Parameters
I forgot to add the timestamp format is:
09 Jan 04 00:0 -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Query Parameters | Excel Discussion (Misc queries) | |||
MS Query - 2 Parameters | Excel Discussion (Misc queries) | |||
Query Parameters | Excel Discussion (Misc queries) | |||
Editing Query Parameters | Excel Programming | |||
Query Parameters | Excel Programming |