Norman.

Worked well thanks.

Now need to direct the newly created workbook to a specified location.
Have read alot of threads but my basics are letting me down. Or lack o
them.

Regards

Krista

--
Kstalke
-----------------------------------------------------------------------
Kstalker's Profile: http://www.excelforum.com/member.php...fo&userid=2469
View this thread: http://www.excelforum.com/showthread.php?threadid=38376