ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to export to fixed width text file? (https://www.excelbanter.com/excel-worksheet-functions/50891-how-export-fixed-width-text-file.html)

Mike

How to export to fixed width text file?
 
I have a layout for a fixed width file that I need to export but cannot find
any information on how to do this. I know how to *import* a fixed-width
file, but can't find any way to export one (the 'prn' option does not seem
to offer any choices on column widths). Thanks for any information on how to
create this type of file.

Mike



JE McGimpsey

How to export to fixed width text file?
 
Take a look he

http://www.mcgimpsey.com/excel/textf...tml#fixedfield


In article ,
"Mike" wrote:

I have a layout for a fixed width file that I need to export but cannot find
any information on how to do this. I know how to *import* a fixed-width
file, but can't find any way to export one (the 'prn' option does not seem
to offer any choices on column widths). Thanks for any information on how to
create this type of file.

Mike



All times are GMT +1. The time now is 08:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com