ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I export an excel file as fixed length records (https://www.excelbanter.com/excel-discussion-misc-queries/15897-how-do-i-export-excel-file-fixed-length-records.html)

iainjh

How do I export an excel file as fixed length records
 
I want to create a record within an export spreadsheet, export this to
another file(not xls) and retain fixed length fields in the exported file.
Does anybody know how this can be achieved?

JE McGimpsey

One way:

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


In article ,
iainjh wrote:

I want to create a record within an export spreadsheet, export this to
another file(not xls) and retain fixed length fields in the exported file.
Does anybody know how this can be achieved?


iainjh

Thanks, I'll give it a go.

"JE McGimpsey" wrote:

One way:

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


In article ,
iainjh wrote:

I want to create a record within an export spreadsheet, export this to
another file(not xls) and retain fixed length fields in the exported file.
Does anybody know how this can be achieved?




All times are GMT +1. The time now is 04:39 AM.

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