Save File
 

I have a file that I want to save using VBA to a space delimited file with
double quote marks around each cell of data.

I figured out how to save the file as an xls but I can not find anything on
saving or exporting the data to a space delimited text file with double
quotes around each cell of data.

Does any one have any ideas?

Thanks in advance for the help!
Mike Charney
m charney at dunlap hospital dot org (No spaces and change the characters)

Save File
 

Take a look at how J.E. McGimpsey does it at:
http://mcgimpsey.com/excel/textfiles.html
(Look for: CSV with quotation marks around each field)

He actually uses a comma, but you could use a space character:

sOut = sOut & "," &QSTR & _
would become:
sOut = sOut & " " &QSTR & _


Mike wrote:

I have a file that I want to save using VBA to a space delimited file with
double quote marks around each cell of data.

I figured out how to save the file as an xls but I can not find anything on
saving or exporting the data to a space delimited text file with double
quotes around each cell of data.

Does any one have any ideas?

Thanks in advance for the help!
Mike Charney
m charney at dunlap hospital dot org (No spaces and change the characters)

--

Dave Peterson

Save File
 

That worked great thanks!!!

Mike Charney

"Dave Peterson" wrote in message
...
Take a look at how J.E. McGimpsey does it at:
http://mcgimpsey.com/excel/textfiles.html
(Look for: CSV with quotation marks around each field)

He actually uses a comma, but you could use a space character:

sOut = sOut & "," &QSTR & _
would become:
sOut = sOut & " " &QSTR & _


Mike wrote:

I have a file that I want to save using VBA to a space delimited file
with
double quote marks around each cell of data.

I figured out how to save the file as an xls but I can not find anything
on
saving or exporting the data to a space delimited text file with double
quotes around each cell of data.

Does any one have any ideas?

Thanks in advance for the help!
Mike Charney
m charney at dunlap hospital dot org (No spaces and change the
characters)

--

Dave Peterson