Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My hyperlink address change? | New Users to Excel | |||
Hyperlink: Why am I getting ../../../ in the address bar? | Excel Discussion (Misc queries) | |||
hyperlink a worksheet with no address | Excel Worksheet Functions | |||
Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
hyperlink base address | Excel Discussion (Misc queries) |