Creating a Dymanic hyperlink address using From Web
 

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

Creating a Dymanic hyperlink address using From Web
 

oops Dynamic is spelled wrong.

Creating a Dymanic hyperlink address using From Web
 

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

Creating a Dymanic hyperlink address using From Web
 

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

Creating a Dymanic hyperlink address using From Web
 

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