All articles with 'file processing using VBA' Tag
{ 32 Comments }
Save a range as text file using VBA [tutorial]
Published on Oct 28, 2015 in VBA Macros
Last night I asked members of our Chandoo.org facebook page to share an Excel problem you are struggling with. Francis asked,
How to save a file as .txt in vba without quotes? When I save as .txt, the file has got quotes inside of it. I used the code Print, but it didnt work because the file loses its delimitation.
Does anyone know how to solve this?
Let’s understand how to save a range as text and overcome the double quote problem.
Continue »