Nar5sup.xlsm is attempting to create folders and .csv files in the subfolders of Column A & Column B. The idea is to create files and folders for each folder name that changes in Column B. My problem is the runtime error (noted in the comment) in Sub WScopy.
The problem stems from using the SaveAs but I am losing control of Nar5sup (ThisWorkbook) because it wants to close via the SaveAs process -- so I am trying to use a temporary worksheet, "Pedro.xls" so when it gets closed I can continue the loop process.
I need help with the runtime error OR how to maintain control of Nar5sup.xlsm after I perform the SaveAs operation.
I hope that is clear .... Dan
Bookmarks