是否有一种方法可以导出和Excel表而不需要复制到工作簿?

I have a workbook that can export the working sheet to a .csv but it copies it into a new workbook for a second before saving im wondering if there is a way just to copy data from the sheet as is without opening a new workbook ? the code i have is:I have a workbook that can export the working s