Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Using Office 2003 and Windows XP; and using using VBA from MS-Excel;
1) There will be several (between 1 and 10) fixed width text files in a specific folder, each formatted the same way; the files range from a few kb to 100kb in size. 2) I need a program that will sequentially open each text file and copy the contents; 3) The contents of each separate text file, along with all formatting, must be transferred undisturbed into a new fixed width text file, appending the contents of each text file into a new SINGLE merged text file; I can already code the part where the list of files is captured and each may be opened and closed. I need help with the part where the data is copied from the text file and then written to the new single merge file. Can someone please post some example code that would help me get started? Should I use FileSystemObject? Or something else? Suggestions? Help? Thanks much in advance for your assistance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Trying to import multiple text files using "fixed width" | Excel Programming | |||
Software to download Fixed Width Files | Excel Discussion (Misc queries) | |||
Best way to import fixed-width delimited text files into an array? | Excel Programming | |||
Basic Q: Field/Array info when importing fixed-width text files | Excel Programming | |||
Fixed Width - Opening Certain Fixed Width Files | Excel Programming |