Share via

Creating .csv file with VBA code without having quotation marks

Ceylin Negüzel 0 Reputation points
2023-02-15T14:31:29.63+00:00

I prepared the VBA code for copying the data from my source file (excel) pasting it into another file and saving it as a separate csv file. After I run the macro, when I open the target csv file in excel format the data seems good however when I open it in notepad I always see quotation marks in the beginning and at the end of reach row. Whatever I did to solve this issue was no success. Does someone know a workaround to get rid of this quotation marks? Thanks in advance.

Microsoft 365 and Office | Development | Other

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.