LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
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






 
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
My spreadsheet will not update new info Confused? Excel Discussion (Misc queries) 0 November 18th 08 03:43 PM
Automatically fill info from another spreadsheet? Christine Excel Worksheet Functions 2 September 19th 06 06:53 AM
new copy of spreadsheet using old spreadsheet info. e_vandenbush Excel Discussion (Misc queries) 1 January 17th 06 03:28 AM
reporting directory info into a spreadsheet Tim[_39_] Excel Programming 3 August 6th 04 11:47 AM
Form info to different spreadsheet Glenn Excel Programming 2 January 28th 04 11:13 AM


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

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

About Us

"It's about Microsoft Excel"