Thread
:
Getting info off the Web into my spreadsheet
View Single Post
#
4
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Getting info off the Web into my spreadsheet
Pascal,
In the future, please send workbook attachments directly to the poster
instead of the ng.
--
Don Guillett
SalesAid Software
"P Daulton" wrote in message
...
Running Macro1 in the attached xls file should get you started. I noticed
that the results pages url addresses had some logic to them, with A
seeming
to mean AM or Matinee and E Evening and S I haven't the foggiest but seem
to
come before the evening performance; the month and day of the month are in
there too, so a loop to go through the possibilities for each day, between
two dates input by the user seems to work. The data go below the
bottommost
used cell in column A of the active sheet.
It would help if you spelt the website address correctly - just go where
you
said to see what fun I had finding button 2.
Pascal
"caldog" wrote in message
...
I know how to obtain data from the web using the import external
function.
But my problem is that sometimes I need to download several
preformances.
Let me explain I'm into greyhound racing their is a track that list
their
results in a drop down box, by performance [
www.mobilgreyhoundpark.com]
,
then
click under button number 2, and click on drop box. Example, February
2,
Matinee, then below this February 7, evening, then again February 8,
Evening.
So on my spreadsheet I want the infomation that protains to the Matinee
performance to go to that part of my spreadsheet. My spreadsheet looks
like
this: 02/07/05 Matinee, then the data that I want by race number.
Under
that is 02/07/05 Evening and so forth.
Any help would be greatly appreciated.
cal
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]