On Oct 14, 10:01*am, p45cal wrote:
Try replacing
ActiveWorkbook.SaveAs ThisWorkbook.Path & Range("TempNumber").Value
with
ActiveWorkbook.SaveAs ThisWorkbook.Path & "\" &
Range("TempNumber").Value

--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile:http://www.thecodecage.com/forumz/member.php?userid=558
View this thread:http://www.thecodecage.com/forumz/sh...d.php?t=143554

You are awesome. It would have taken me a year to stumble on that
solution.
Thank you very much.
j.o.