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" <jim.coneXXX@rcn.comXXX> wrote in message
news:O4KmVdCOGHA.720@TK2MSFTNGP14.phx.gbl...
> 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" <madw@ake.quik.co.nz> 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
>
>