space delimited!!
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. |
space delimited!!
"Jason" wrote in message ... 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. Record a macro while you're going through the steps manually. Then, edit the macro, if necessary, to make it more generic. |
space delimited!!
Doug Kanter is on the right track for a simple solution. While recording, File Print ... checkmark the Print to File box "Jason" wrote: 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. |
All times are GMT +1. The time now is 09:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com