VBA code to split sheets and save as seperate CSV files

Hello

I am wondering if anyone can help.

I have a spreadsheet that we receive that contains 8 different sheets.

I am looking to create a macro that splits these 8 different sheets into seperate workbooks and saves them as a CSV file?

Thanks

McC

This will work with up to 8 worksheets, it will name each new CSV workbook by the name of the actual worksheet being moved. It will leave the original workbook intact (As a backup, I did not want to delete sheets from the original workbook.)

Please Login or Register  to view this content.

Hi

I have tried running the above code, however, nothing appears to happen?

Any suggestions?

Thanks again
Much appreciated

Hi

Can anyone help please?

Thanks

Hi

Thanks for getting back to me.

I have already changed the file path to my own drive and it still does not appear to work?

Thanks again

Please post a copy of your workbook, I may be able to offer more help.

I took the above code and tweaked it a bit:

Please Login or Register  to view this content.

You have to distinguish the final sheet, because you cannot move a sheet out of a document if it is the only sheet. This also resolves any issues on the naming of the tabs (the prior version required that the sheets be named "Sheet3").

I believe you weren't getting any error messages because the code suppressed those. I did not include those, because I need to know why something didn't do what I thought it would.
I hope this helps.
J