Stop original workbook from closing

[mattless1]

Hi,

i have a script below which exports sheet1 to csv file. is there a way to stop the original workbook from closing. as it closes the original workbook and leaves the exported one open. i would like to close the export and still edit the original workbook.

current script.

many thanks,

[BadlySpelledBuoy]

You're using SaveAs, which effectively turns the current work book into the one you're saving, rather than actually closing the original one.
Try using SaveCopyAs instead.

BSB

[mattless1]

Thanks,

i have tested that, but it copies the entire workbook i'm only looking to copy sheet1.

i renamed to below as you suggested.

i removed FileFormat:=xlCSV from the end as it would return an error if lett in.

[BadlySpelledBuoy]

Maybe this will help.

Please Login or Register  to view this content.

BSB

[mattless1]

Thank you, that works a treat, i just need to alter it to select the folder i want to save to, and only copy from row three.

many thanks again.