MkDir not working

[pprseller]

I have the following code (that I borrowed) and was using it to export some worksheets to a new workbook. It worked fine for about 4 times, now it says it can't find the file path and stops on the "MkDir FolderName" line.

Please Login or Register  to view this content.

The sourcewb is in a folder on my desktop. When this worked correctly, it created a new folder within that same folder. (I haven't moved anything.) That would be great but I'm over my head here... Any help is greatly appreciated. Thank you!

[shg]

Please Login or Register  to view this content.

A colon is not a valid character in a file name.

[pprseller]

I just thought of that! D'oh!
Thank you!