Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
iainjh
 
Posts: n/a
Default 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?
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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?

  #3   Report Post  
iainjh
 
Posts: n/a
Default

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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel to Excel, Cut & Paste, 1 cell, text, multiplies file size f. PboB Excel Discussion (Misc queries) 3 March 16th 05 06:17 PM
Excel file modification date GROSNER Excel Discussion (Misc queries) 5 March 4th 05 01:19 AM
How do I override fixed decimal place settings in EXcel 2003? jroyv Excel Worksheet Functions 2 February 11th 05 06:07 PM
Problem Opening An Excel file. - by yk ilikecy Excel Discussion (Misc queries) 0 February 4th 05 08:19 AM
Export to fixed width text file FinChase Excel Discussion (Misc queries) 0 January 24th 05 07:25 PM


All times are GMT +1. The time now is 11:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"