Saving to a .csv file and only 1st row contains quotes

I am trying to create a .csv file from an Excel file using VBA and when I use the ActiveWorkbook.SaveAs command, only the first row of text contains " quotes around the text. I have multiple rows that must contain the quotes. I have tried using """", and Chr(34), but then that puts """ (3 quotes) around my text. Is there a different function that I should be attempting to use? I am using concatanation to create a field where I would like the quoted text and am using the ActiveCell.Value command (ActiveCell.Text didn't seem to make any difference).

I have commented out the text in my EndRoutine() subroutine that does the actual file saving. If you need to uncomment it to test, you'll need to use your own path of course.

Hi Leith,
Yes, I am wanting the Automatic Summary cell to have quotes at the beginning and end of the 3 line paragraph. My experience has been that even if I use the Chr(34) at the beginning and end, saving it as a .csv file gives me unpredictable results. For Example: If I use Chr(34) at the beginning and end, I will wind up with 3 double quotes """ at the beginning and end. If I don't use Chr(34), the maybe the first row will have quotes, but the subsequent rows won't. I thank you for your diligence in this too very much.
Bob

That would be great Leith! Thanks!

Dear Leith,
That works great!

I'm now learning that they are trying to read this file in to VB and saving it as a .csv file is adding additional quotes (I see this when viewing it via notepad).

Alas, now I'm being asked to not save it as a .csv file but to just write a text file so I guess I'll look into another avenue and a slightly different post after I do some more reading and googling

Thank you for all your hard work and persistence, I really appreciate it.
Bob