Save a selection as a txt (without quotes)

[James bolton]

Hi,

I would like help with what I presume would be a simple Macro, I just need to be able to save the "current" (highlighted) selection as a .txt file.

I got close - but the newly saved txt file contains quote marks " at the beginning of each sentence (each row), please can you help me with a Macro that saves the current selection as a .txt without these annoying quote marks.

Many Thanks

 

[Chihiro]

See link. This will give you good starting point.
http://stackoverflow.com/questions/...lect-range-for-exporting-from-excel-to-a-file

 

[Deepak]

http://chandoo.org/wp/2015/10/28/save-range-as-text-using-vba/

 

[James bolton]

thankyou both