Save as space delimited file from VBA

  • Thread starter Thread starter Nash
  • Start date Start date
N

Nash

Hi,
I'd like to save my file from VBA, but as a space delimited file,
i.e.with a single space between cell values. Does any of xlFileFormat
values produce this result? I really don't feel like testing each
one...

TIA,
Nash
 
Hi

I don't think that you can do it but there are a couple of options that I
can think of to solve it:

1. As as a CVS and then convert all commas to spaces (although this may
cause problems with other commas in the file.

2. save as a .prn formated text file and then delete mutliple spaces.

Have a think about or see what others come up with.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Saving a Text 2
Save as Shift-JIS? 0
Excel VBA help: Text file formatting 19
Split with consecutive delimiters 5
Exporting Worksheets from a workbook and saving them as a .prn file 1
How to tell spaces between values in saved text file from theoriginal xls file 2
writing data to a tab delimited text file? 2
Issue with blanks and spaces 56

Back
Top