Building custom solutions that extend, automate, and integrate Microsoft 365 apps.
Creating .csv file with VBA code without having quotation marks
Ceylin Negüzel
0
Reputation points
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
Microsoft 365 and Office | Development | Other
Sign in to answer