View Single Post
 
Old 02-26-2020, 08:55 AM
gedinfo2020 gedinfo2020 is offline Windows 10 Office 2019
Novice
 
Join Date: Feb 2020
Posts: 4
gedinfo2020 is on a distinguished road
Smile Replace " in string sent to output file

Hello, I am sending a csv formatted data to an output file, and find that the string that I put the data into ends up with " at the start, followed by a CR\LF and " at the end.
I do not directly enter the leading " or the ending CR/LF ".

I have screen shots saved as .png to demonstrate what I mean, but do not have web storage for these.

Via VBA, I wish to eliminate the extra 'formatting', as this causes the csv file to not be imported into Excel correctly.

Thank you for any suggestions.

Last edited by gedinfo2020; 02-26-2020 at 11:35 AM. Reason: attempt to add image attachments
Reply With Quote