Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |