Save as space delimited file from VBA
 

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

Save as space delimited file from VBA
 

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.

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Nash" wrote:

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