Is there a way to save a worksheet using VBA to a text file without any delimiters like commas or tabs?
I tried recording my self saving files as a way to make the code but my output is getting random double quotes at the beginning and ending of some lines.
also is there a way to save files with an extension excel doesnt usually use? The program that will be reading in the text file is set to some old ball extension name.
Thank you
I tried recording my self saving files as a way to make the code but my output is getting random double quotes at the beginning and ending of some lines.
also is there a way to save files with an extension excel doesnt usually use? The program that will be reading in the text file is set to some old ball extension name.
Thank you
