Article ID: 141509 - View products that this article applies to.
This article was previously published under Q141509
The "More Information" section of this article contains sample Microsoft Visual Basic for Applications macros (Sub procedures) that you can use to append the contents of one text file to another.
Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements. In the following macro examples, the AppendFiles1 and AppendFiles2 macros take the data from one text file, Source.txt, and append it to the data in the Dest.txt text file.
To set up the example, use a text editor such as Windows Notepad to create the following text files.
The Dest.txt file should contain the following information:
The Source.txt file should contain the following information:
Last Name, First Name, Address, City, State, Zip Code John,Smith,1 Main St.,Seattle,WA,12345 Jane,Doe,2 East Rd,Charlotte,NC,52631 Tom,Jones,3 West Cir.,Tuscon,AZ,36258
Bill,Adams,6 Elm Ln.,Seattle,WA,85692 Sue,Thompson,33 Maple Ct.,Las Colinas,TX,58692 Jerry,Brown,32 Main Rd.,Tuscon,AZ,96524 Pamela,Smith,88 Rain Rd.,Charlotte,NC,89526
Method 1Use file input and output (file I/O) commands in a Visual Basic macro.
The following macro demonstrates how you can use the Open, Line Input, and Print statements to read data from one text file and append it to another.
Method 2Use the MS-DOS "copy" command. This method applies only to Microsoft Excel for Windows or Windows 95.
The following example runs the MS-DOS "copy" command to append two text files.
NOTE: When you use the Shell command to execute a command in the command interpreter (Command.com), use the /c switch followed by the command. The /b switch can be used with the Copy command to indicate that an end-of-file character should not be added to the destination file.
After you run either macro, Dest.txt should resemble the following:
Last Name, First Name, Address, City, State, Zip Code John,Smith,1 Main St.,Seattle,WA,12345 Jane,Doe,2 East Rd,Charlotte,NC,52631 Tom,Jones,3 West Cir.,Tuscon,AZ,36258 Bill,Adams,6 Elm Ln.,Seattle,WA,85692 Sue,Thompson,33 Maple Ct.,Las Colinas,TX,58692 Jerry,Brown,32 Main Rd.,Tuscon,AZ,96524 Pamela,Smith,88 Rain Rd.,Charlotte,NC,89526
In Microsoft Excel for Windows 95 version 7.0, for more information about writing data to files, click the Index tab in Microsoft Excel Help, type the following text
Files, Writing Dataand then double-click the selected text to go to the "Writing Data to Files" topic.
In Microsoft Excel 5.0, for more information about "Writing Data to Files" choose the Search button in Help, and type:
Writing DataChoose the Show Topics button, select the topic, and choose Go To.
For additional information about getting help with Visual Basic for Applications, please see the following article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/163435/EN-US/ )VBA: Programming Resources for Visual Basic for Applications
Article ID: 141509 - Last Review: October 11, 2006 - Revision: 2.3
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.