Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
ron ron is offline
external usenet poster
 
Posts: 118
Default 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   Report Post  
Posted to microsoft.public.excel.programming
ron ron is offline
external usenet poster
 
Posts: 118
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting data from a webpage Southern at Heart Excel Programming 3 March 23rd 10 04:01 AM
Saving data to a webpage steve New Users to Excel 2 February 24th 08 09:00 PM
getting data from website's url and webpage [email protected] Excel Programming 1 February 10th 08 10:12 PM
Code to get data from webpage into Excel donbowyer Excel Programming 5 January 1st 06 03:25 AM
data from external webpage R.VENKATARAMAN Excel Programming 2 August 23rd 05 06:56 AM


All times are GMT +1. The time now is 10:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"