Getting info off the Web into my spreadsheet

[Guest]

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

 

[Guest]

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

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

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

 

[P Daulton]

I use Outlook Express, if I click (or right click) the paperclip at top
right of the the message in the preview pain, it allows me to save the
attachment. Alternatively, double click the message to bring it up in its
own window then it appears below the 'Subject', where I can right click and
save as.. (I have successfully downloaded my own attachment this way)
The news server is msnews.microsoft.com, the group is
microsoft.public.excel.programming

Web access to the newsgroup doesn't seem to feature attachments.

There is a link on this page:
http://www.news2mail.com/microsoft/public/excel/programming.html
in the bit which reads:
"Clicking onthis linkshould open this group in your Newsreader. "
which purports to do what it says on the tin - I haven't tried it.
Pascal

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

Running Macro1 in the attached xls file should get you started. I noticed [snip]
Pascal

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 [snip]
cal

 

[Don Guillett]

Pascal,
In the future, please send workbook attachments directly to the poster
instead of the ng.

--
Don Guillett
SalesAid Software
(e-mail address removed)

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

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