LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #12   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,182
Default Merge several fixed width text files into one

Hi Garry,

Am 14.06.2017 um 00:58 schrieb GS:
Nice to see you 'spreading your wings'!<g

Why not? ;-)
FWIW:
My experience with users for this type of utility is (typically) where a
share folder is used as a repository for collecting data from various
sources over a given period. Once per period the data gets consolidated
into a single file for processing further by some means, and the source
files get deleted so the folder only contains un-processed data files.

That said, your example could be modified to drill drown a selected folder
(and optionally, subfolders) so the user doesn't have to specify filenames.
Your sample addresses EXACTLY what the OP states is wanted; -I'm guessing
that's not the 'actual' scenario...<g


In the old days this was a classical job for some commands from the command
line. My intention was to bring this technique back to memory and how we can
use it now a days. Of course this can also be done with some vba but what
about the fun?

Ulrich


Ha, ha! The 'fun' only exists for the old timers, right! These days we only see
newbie OPs (which I am one of in the Classic VB forums), mostly looking for
'turn-key' solutions and so won't appreciate your offering same as I do!<g

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 
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
Trying to import multiple text files using "fixed width" [email protected] Excel Programming 4 August 15th 07 08:04 PM
Software to download Fixed Width Files create_share Excel Discussion (Misc queries) 1 December 31st 05 09:41 PM
Best way to import fixed-width delimited text files into an array? KR Excel Programming 1 March 3rd 05 02:40 PM
Basic Q: Field/Array info when importing fixed-width text files KR Excel Programming 0 March 1st 05 09:02 PM
Fixed Width - Opening Certain Fixed Width Files Jan[_8_] Excel Programming 2 December 30th 03 08:31 PM


All times are GMT +1. The time now is 07:19 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"