Save and close newly created CSV workbook

Originally Posted by jindon

What is "main original sheet"?

Sorry the sheet that runs the macro.

Its basically a blank Purchase order form, they fill out the PO order details, run the macro that will extra the data to the CSV, then save the Purchase order again as a seperate file excel file, with the filename of the PO, but with the PO number, written in J4 on the end of the file name, So "Purchase Order 123"