Double Quotes using Chr(34) and Extra Quotes when saving as text file

I am in charge of a SharePoint site and I have a scrolling Marquee that I want some of my fellow coworkers to be able update. Problem is most of them will mess up the HTML code that drives the Marquee. My solution was to give them a spreadsheet that creates takes their typed messages, creates the html code, and saves it to a text file.


My problems!

1) Somehow the first two lines of text start and end with quotation marks that were not placed by me (not on purpose anyway)

2) Somewhere in the transition from Excel to Text file it adds some quotations in other places where Chr(34) is used.

Overall HTML Code generated:

HTML Code: 

Lines that I see in Excel:

HTML Code: 

Here is the code I am using:

Please Login or Register  to view this content.

Still pretty new to the vba world, so not quite understanding part 2 of your reply. As for part one, I went through and replaced all Chr(34) with the "&#34" and while it did remove the quotations at the first two lines, all internal double quotes now show up with the text &#34.

HTML Code: 

Could you explain the "Reference" parameters a little to me. You tell me to add them but this is another function I am not too familiar with. I do a lot of logical pattern items (activecell.offsets, if statements, loops, etc...). Mainly the stuff I can easily follow as I step through it.

In the Visual Basic Editor (VBE), select the menus, Tools > References. Select the object named, MicroSoft Forms 2.0 Object. This lets you use the methods and properties of that object. e.g http://www.officecoders.com/2012/07/...s-provide.html

If you have not added the Compile button to the VBE, do that. Always Compile code before you try to run it. Otherwise, during runtime you will see an Object error.

Thank you very much for your time there Ken. After some tweeks to it I was able to get it working pretty much for what I need. Only issue I was unable to overcome was saving it to a web folder which I don't think will be possible through VBA. So I got it set up to where the code saves itself as a text file on the individuals desktop and they can upload the text file which drives the marquee. Pretty simple for the end user. I have tried it out and it is as close to sailor proof as I will get it for now. I have attached the final code.

Once again, thank you for your time.

Please Login or Register  to view this content.

You might have noticed that only lines that contain double quotes " are being 'wrapped' in added double quotes "
So it's easy to remove these:

Please Login or Register  to view this content.