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/tradi...th20080421.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

oops Dynamic is spelled wrong.

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

I'd use a formula:

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

wrote:

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/tradi...th20080421.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

--

Dave Peterson

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

wrote:

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/tradi...th20080421.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

--

Dave Peterson