Hi Jim,
It works! I'm impressed. I also need to change the NR05 each day but will do
that later.
Thanks for your help
Ta,
Martin

"Jim Cone" wrote in message
...
Martin,
Perhaps...

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

Regards,
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Martin Wheeler" wrote in message...
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