Post the code you are using with the SaveAs method, and describe
in detail the errors you are getting.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"N E Body" wrote in
message ...

Sorry Chip I think it must be Friday afternoon syndrome but I
cannot get
my head round this one!

I tried changing it to ThisWorkbook.SaveAs and
ActiveWorkbook.SaveAs
but still get various errors.

Kenny


--
N E Body
------------------------------------------------------------------------
N E Body's Profile:
http://www.excelforum.com/member.php...o&userid=11263
View this thread:
http://www.excelforum.com/showthread...hreadid=320594