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

I forgot to add the timestamp format is:

09 Jan 04 00:0

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

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/

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/

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/