In VBA, we use """" for one quotation mark, it has not issue to display one quotation mark in Excel cell. But when we save the excel file as txt file, the one quotation mark turning to two quotation marks.
Actually, I don't really care how it displays in Excel cell, how should I modify the code to show only one quotation mark in txt file (when saving the excel file to txt file)?
Thanks.
Bookmarks