View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
caldog caldog is offline
external usenet poster
 
Posts: 111
Default Getting info off the Web into my spreadsheet

Pascal,

Thanks for responding to my question. Sorry about dropping the letter "e"
in the web address.

Since I am new to these discussions group, I have one more question. Where
or how do I see your attached file, becasue first looking at your reply, I
just don't see it. BTW, S stands for schooling in greyhound logic.

cal

"P Daulton" wrote:

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