Ron de Bruin wrote:
Hi AccessUser777

Send me your file private and I will look what is the problem

Also not use a/ in the date format, use - for example
the / is not allowed in a workbook name

TempFileName = "CHANGEBACK LOG FOR " & Sourcewb.Name & " " & Format(Date, "MM-DD-YYYY")
Hello All,

[quoted text clipped - 128 lines]
End With
End Sub

Hi Ron,
Thank you for your reply...and actually your reply is what fixed the problem.
All I had to do is change the "/" in the date format and your code worked
perfect. Thanks again!!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/201001/1