What are the extra bits?

When I put that formula in a worksheet cell and clicked on it, I went to:

http://www.tabonline.com.au/2006/02/23/NR05.html

Which seems to match what you asked for.

Martin Wheeler wrote:

Hi Dave,
I just tried this and all I got was the main page.
It did not add the extra bits.
Ta,
Martin

"Dave Peterson" wrote in message
...
This isn't VBA, but maybe you could just use =hyperlink().

Like:

=HYPERLINK("http://www.tabonline.com.au/"
&TEXT(TODAY(),"yyyy/mm/dd")&"/NR05.html", "Click Me")

(all one cell)



Martin Wheeler wrote:

xl2003, winXP

I have a range of 10 URLs. A10-A19 Each day I need to update them to the
current date. The URL looks like:-

URL;http://www.tabonline.com.au/2006/02/23/NR05.html

So tomorrow I will want to be able to push a button and /2006/02/23
becomes
/2006/02/24 in all 10.
I need to do this programatically as it will be part of a series of
operations.
Any help would be greatly appreciated.
Ta,
Martin

--

Dave Peterson

--

Dave Peterson