software

could anybody tell me how to save the file in the formatt, .prn using the
file type, formated space delimited, (by using vba)?...i tried to use
workbooks.save(path and filename), it saves it as prn, but dos does not read
it, so, i wanted to know how to save the file, as the file type, prn.


quot;Jasonquot; gt; wrote in message
...
gt; could anybody tell me how to save the file in the formatt, .prn using the
gt; file type, formated space delimited, (by using vba)?...i tried to use
gt; workbooks.save(path and filename), it saves it as prn, but dos does not
gt; read
gt; it, so, i wanted to know how to save the file, as the file type, prn.

Record a macro while you're going through the steps manually. Then, edit the
macro, if necessary, to make it more generic.

Doug Kanter is on the right track for a simple solution.

While recording,
File gt;gt; Print ... checkmark the Print to File box
quot;Jasonquot; wrote:

gt; could anybody tell me how to save the file in the formatt, .prn using the
gt; file type, formated space delimited, (by using vba)?...i tried to use
gt; workbooks.save(path and filename), it saves it as prn, but dos does not read
gt; it, so, i wanted to know how to save the file, as the file type, prn.