Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input Data to Webpage
I've been trying to write a macro to interact with the following
website: http://matrix2.itasoftware.com/ I do pretty standard stuff like.. Set ie = CreateObject("InternetExplorer.Application") With ie .Visible = True .Navigate "http://matrix2.itasoftware.com/" .Top = 0 .Left = 30 .Height = 400 .Width = 400 to open ie to the webpage, and I use code like... Set ipf = ie.Document.all.Item("from1") ipf.Value = depart_arpt Set ipf = ie.Document.all.Item("to1") ipf.Value = arrival_arpt to isert information into the webpage. I can insert my data into all of the webpage boxes except for the drop-down box to the right of the phrase "Departing in". I can't figure out how to make a selection in this box. I've tried code like... ie.Document.all.Item("dijit_MenuItem_6").Click but it won't select one of the months available in the drop down list. Interestingly, if I go and manually click in this webpage box, and then go back to my paused macro, the above line does work and the correct month/year appears in the drop down box. Any help on how to make this selection without having to manually click the box would be much appreciated...TIA, Ron |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input Data to Webpage
On Jul 20, 4:19*pm, ron wrote:
I've been trying to write a macro to interact with the following website: http://matrix2.itasoftware.com/ I do pretty standard stuff like.. * * Set ie = CreateObject("InternetExplorer.Application") * * With ie * * * * .Visible = True * * * * .Navigate "http://matrix2.itasoftware.com/" * * * * .Top = 0 * * * * .Left = 30 * * * * .Height = 400 * * * * .Width = 400 *to open ie to the webpage, and I use code like... * * * * Set ipf = ie.Document.all.Item("from1") * * * * * * ipf.Value = depart_arpt * * * * Set ipf = ie.Document.all.Item("to1") * * * * * * ipf.Value = arrival_arpt to isert information into the webpage. *I can insert my data into all of the webpage boxes except for the drop-down box to the right of the phrase "Departing in". *I can't figure out how to make a selection in this box. *I've tried code like... * * * * ie.Document.all.Item("dijit_MenuItem_6").Click but it won't select one of the months available in the drop down list. *Interestingly, if I go and manually click in this webpage box, and then go back to my paused macro, the above line does work and the correct month/year appears in the drop down box. *Any help on how to make this selection without having to manually click the box would be much appreciated...TIA, Ron Whoops, I should have mentioned that you need to select the "See calendar of lowest fares" radio button option ie.Document.all.Item("rt_calendar").Click in order to see the "departing in" line and drop down box I was referring to...Ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting data from a webpage | Excel Programming | |||
Saving data to a webpage | New Users to Excel | |||
getting data from website's url and webpage | Excel Programming | |||
Code to get data from webpage into Excel | Excel Programming | |||
data from external webpage | Excel Programming |