Convert CSV file to XLSX without saving it

[fabian_76]

Hi I have the following code to send the current workbook via Outlook but it is sent as .csv, is it possible to convert it to .xlsx without saving it?

Please Login or Register  to view this content.

[TMS]

Generally, the approach is to copy the sheet to a new workbook, save the new workbook (as a csv file) to a temporary file name and location, attach the temporary (csv) file to the email, and then kill (delete) the temporary csv file.

You can only save a single sheet to a csv file so, if the workbook has more than one sheet, you'd have to do each one separately.

But, still, doable.

[TMS]

Sorry, misread the requirement. But the principle is the same. Save to a temporary Excel file, attach and kill.

[TMS]

Thanks for the rep.