Martin,

An additional note. The code I posted will work even when the domain name
changed at a later date, or even when you go for https instead of http later.
Because it actually "hunt" for the position of the end of the domain name and
pluf the date into it and then plug the rest of the URL.

Edwin


"Martin Wheeler" wrote:

Hi R,

Jim's function works very well so I will use it for now But might go to
Edwin's or Mudraker's code when I develop it further

Thanks for your help.
Ta,
Martin



"R..VENKATARAMAN" wrote in message
...
I tried to use today() in spread sheet it comes as serial no. of date in
vba it comes as 2/23/2006

so I formatted a series of cells e.g. A6 to a15 as TEXT
in A6 as 2006/2/23
I filled serially down to A15(it is easy to do this in excel 2002-you
click right bottom of A6 and drag it down and click smart tag and click
fill series

now in B6 you type
=$A$1&A6&$A$2
take care of dollar signs
now copy B6 down to B15
will this be useful to you.

may be more elegant solutions are there.
.

"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