Save As

[Kevin]

Is it possible to create a cutom save format? I need to
export data that is comma and quote delimited
("X","Y","Z") which doesn't appear to be a native format
for Excel. This is the only format this antique target
system can upload.

Any suggestions?

Thanks in advance,

Kevin

 

[Dave Peterson]

You could write your own macro to do the work or....

try Earl Kiosterud's Text Write program:
http://www.tushar-mehta.com/
Look for Text Write in the left hand frame.


Some sample code can be found here:

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html