LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default grabbing data from another website

Good afternoon,
Thanks in advance to whoever can help me, i am very, very interested
in a solution if one can be given. I run a detailed statistical
database of sports statistics, which is required to be updated each
morning. I have dozens of tabs within the excel sheet, which, as of
right now, I manually update by going to a webpage, copying all the
data in a table, and re-pasting it in my spreadsheet. That pasted data
then auto-updates all the other tabs within the spreadsheet.

Then I save the spreadsheet as a webpage, and upload it to the net.

My question is... is there a better way I can do this, with some kind
of macro or script? Here is one of the exact pages I need the data
from: http://www.sportsline.com/nhl/stats/...rint_rows=9999

Is there a way that either:
(A) By clicking one "update" button or simply opening the excel sheet
in the morning, it will automatically grab all this data for me from
the webpage?; or even better:
(B) Can I program something in whereby it will automatically update on
its own on the web, so that I don't even have to open the spreadsheet,
update the tabs, upload, etc? Or am I dreaming?

I have very limited programming/design experience, but can figure
things out pretty easily. If someone could point me in the right
direction or give me a few sample lines to write, or info on the web
or something, I would REALLY appreciate it!

thanks so much
Dave
 
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
Grabbing data between worksheets andrew Excel Discussion (Misc queries) 4 July 7th 08 05:39 AM
Grabbing data from 1 sheet to place in another prem New Users to Excel 1 May 3rd 08 12:47 PM
Grabbing data from a specific cell *Kenneth* Excel Worksheet Functions 2 March 18th 08 10:31 PM
Grabbing the filtered data in a list? [email protected] Excel Worksheet Functions 3 August 23rd 06 03:33 AM
Grabbing the filtered data in a list? [email protected] Excel Worksheet Functions 0 August 22nd 06 09:59 PM


All times are GMT +1. The time now is 05:19 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"