We subscribe to stock market data from a third party data provider. They have
an Excel extension which allows us to embed formulas which will pull in
current stock market data to a spreadsheet. I am building an excel
spreadsheet that will use these formulas to track data on a list of
companies. I want to refresh this data on a weekly basis using some kind of
automatic scheduler. My goal is to automate this process, so that every week
the spreadsheet updates itself.

What's the best way to automatically refresh the data in an excel
spreadsheet on a scheduled basis?

I'm using Excel 2000.