View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default 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