Tag Archives: Write

How to Open Files Using VBA

Handling other files in VBA macros As a programmer, you’re likely to come across many situations where other files need to be opened for reading, writing, or appending data. A macro can help you easily handle these files, and the Open method is your ticket.

No Thumbnail

VBA Excel, Writing to a Text File

In this article I will explain how you can create a text file and how write data to a text file in overwrite and append modes.  You can download the file and code related to this article here. Create a text file using the file system

No Thumbnail

VBA Append Data to Text File

In this article I will explain how you can append data to a text file. I am assuming readers are familiar with modifying text files. If you are not familiar with modifying text files I’d recommend taking a look at the this article first VBA, Modify

No Thumbnail

Append Data to Table, Access VBA

In this article I will explain how you can append data to an Access table using VBA. The article uses the ADODB.Recordset object. In order to use this object you may need to add reference to ADODB object library. For more information on this topic please see the