How to export an excel file to csv with quotes

Good day,

Is there a process where I could export an excel file to csv but have quotes added to the export file.

At the moment, after the export to csv, I use a text editor to search and replace the comma for quotes-comma-quotes.

Tx for your help,

Yves

Run the following code when the data sheet is active. The macro assumes that the tabular data starts from cell A1.

Please Login or Register  to view this content.

Artik

Tx Artik

Is there a modification that would make the csv file location the same as the source file?

Tx

Yves

In my opinion, there is nothing to modify. The CSV file is saved in the same folder as the source file.

Artik

Hi Artik,

It does not on my system.

I have the file sitting in c:\TEMP\TESTQUOTES\ and the TestCsvQuotes.csv is being written at C:\Users\yves.davignon\AppData\Roaming\Microsoft\Excel\XLSTART

At first, I did not think the macro was working until I closed and re open excel. The file being in the XLSART folder, the csv open.

Yves

From your description, I conclude that the source file is not the file from which you run the macro. In that case, you should change the reference from this workbook to the active workbook.
Change the line:

Please Login or Register  to view this content.

Artik