copy/move all auto generated ws in one folder

[Pi*]

Is there a way to have all the worksheets created and moved out of the original workbook all saved in one folder? the maro below works but it saves the copied worksheets in seperate folder but I want in all in one folder.

Any advice or help will be apprcitaed;

Please Login or Register  to view this content.

Thanks

[alansidman]

Because you have not provided the full code, it appears that you may have something happening in the unseen code which is causing this. You have an End With without showing the start and you have two end ifs without showing the If statements. Please post the whole code for analysis.

[Pi*]

This is the code,

Please Login or Register  to view this content.

[alansidman]

It appears to me that because this bit of code is inside the For each MyCell that you are creating a new folder with each loop of MyCell. Place the code to create the folder outside of the loop and you will probably be ok.

Please Login or Register  to view this content.

[Pi*]

Hi Alansidman. Whe I do as you suggested by placing it after "Next MyCell" in the macro, I get a Run - time error 1004 "Microsoft Office Excel cannot access file C:\....There are several.." and it highlight

Please Login or Register  to view this content.

Any ideas?

Thanks

[alansidman]

I would place it before the For Each MyCell. I am not entirely sure this will solve your issue. It just seemed logical to me.

[Pi*]

That was a smart and logical suggestion Alansidman! For every instance of updating/reshreshing the newly created workbook, it moves it to the folder and saves it.

Thank You! Sir.

PS.
This issue is resolves but I had a side question. If any of the sheets it moves to the folder is saved as an .xlsm, will the macro in that file still work?

Thanks again Alansidman I appreciate all the help.

Pi*

[alansidman]

If the macro is in the saved files and saved as an .xlsm then if all conditions in the macro are met, it should work.