A macro to save to text... without delimiters or quotation marks.

[Oliver Dewar]

Hi my gurus of excel!

I need to take the text string from a range of cells and put it into a text file (.html) as an exact copy with no added extras.

Am I missing a simple solution? (I hope so)

I've tried fileformat xltextprinter, this only seems to copy a very small amount of text.

xltext puts quotation marks everywhere.

I thought I had it... but then didn't when I stumbled across a solution listed here:
http://www.excelforum.com/excel-programming/585146-macro-to-copy-data-from-excel-to-notepad.html

It uses system objects. But it changed my apostraphes into (x92) and so was not a success.

If someone has a solution I'd be so greatful.

Regards,

Oliver

 

[Oliver Dewar]

OK... I'm going to post my own answer.

The method described on the link in my original post does work but it doesn't preserve some symbols commonly used is writing. Now for my purposes (HTML) there is a way around this: replace the symbols with their corresponding html code (which is better practice anyway).

Hope that helps someone out there apart from me!