Creating a Dymanic hyperlink address using From Web

[db_murray]

I have to get info from the internet everyday. It is posted on the
web in the form of text lists on a webpages

Example:
http://www.amex.com/amextrader/tradingData/data/RegSHO/daily/AMEXth20080421.txt

The address changes every day to account for changes in the list. The
variable in the hyperlink is the date ie "20080421".

What is the best way to have the hyperlink change to access the most
current data using "from web" in Excel?

Thanks,

Dan

 

[db_murray]

oops Dynamic is spelled wrong.

 

[db_murray]

To add to the first post. Can I reference a hyperlink address in a
cell in the From Web tool in Excel?

 

[Dave Peterson]

I'd use a formula:

=hyperlink("http://www.amex.com/amextrader/tradingData/data/RegSHO/daily/AMEXth"
& text(today(),"yyyymmdd")&".txt","Click me")

 

[Dave Peterson]

And the worksheet formula that I posted doesn't retrieve the text file--it just
creates a hyperlink to that URL.