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.
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!Please Login or Register to view this content.
Bookmarks