Appending to a Non-Document Text File

Summary: Do you need to write information out to a text file so it can be used by other programs? You can easily accomplish this task using a macro, as described here. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

When using a macro to write information to a text file, you may want to add information to an existing file, rather than creating a new text file from scratch. To do this, all you need to do is open the file for Append rather than Output. The following code shows this process:

Open "MyFile.Dat" For Append As #1
For J = 1 to NewValues
    Print #1, UserVals(OrigVals + J)
Next J
Close #1

When the file is opened for Append mode, any new information is added to the end of the file, without disturbing the existing contents.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2536) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

A Picture is Worth Thousands! Your worksheets are not limited to holding numbers and text. You can also add graphics or easily create charts based on your data. Excel Graphics and Charts, available in two versions, helps you make your graphics and charts their absolute best.

Check out Excel Graphics and Charts today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Appending to a Non-Document Text File