SaveAs a Worksheet to another file/folder while keeping the original open/active

I have an Excel Worksheet (let's call it "AA.xlsm") which uses VBA code to loop through column A, update column B with some results/values, and then (for each value in column A) SaveAs the worksheet into a different filename/path as a ".csv" type file.

My line of code for the SaveAs is as follows:
Workbooks("AA.xlsm").SaveAs LEpath & CurrFldr, FileFormat:=xlCSV

My problem is that my original worksheet, AA.xlsm, gets closed whereas I need it to stay open/active after each SaveAs iteration.

I hope I made myself clear .... ~Dan

If you use SaveAs, you'll need to add a new workbook, move all your data you want to export to that WB, then SaveAs.

Or you could write the data out yourself using VBA commands.

Are you trying to save one sheet out of the workbook, it's not clear?

Please Login or Register  to view this content.