LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default WRITING TO A TEXT FILE WITH SPECIFIC FORMAT

Help please!
I need to take info from an excel spreadsheet and put it
into a text file. The text file has to have a specific
length and format (not comma delimited). Each row would
start with the date and follow with 24 values with a space
between (fixed format, f 5.0). I have found books talk
about writing with comma delimited, but not fixed format.

Any help or examples would be greatly appreciated. I would
like to do this with VBA.

010103 xxxxx xxxxx xxxxx ...up to 24
010203 xxxxx xxxxx xxxxx ...up to 24
..
..
..
..
 
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
Change Date Format to Specific Text Format When Copying [email protected] Excel Discussion (Misc queries) 4 December 23rd 08 03:43 PM
Date format/Writing to a file problem clayton Excel Discussion (Misc queries) 0 August 8th 06 01:31 AM
Writing a text file from Excel using VBA ... a small issue ajames54 Excel Programming 3 December 3rd 03 03:35 PM
Enforcing specific format in Text Box Kirk[_2_] Excel Programming 1 August 27th 03 02:58 PM
Writing multilines to a text file without closing ccdubs Excel Programming 1 July 10th 03 07:43 AM


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

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"