Vba clear text file content

Line Input 1, strLine. The line below passes the string strLine to the function ModifyColumn3. The return value from the function ModifyColumn3 is then concatenated with the string strFinal.

The function ModifyColumn3 receives as input a line of text from the original text file. The result is an array with 3 strings. The next line concatenates the first 2 columns without making any changes.

This is done in several steps:. Step 1: First the numeric part of the string is extracted. Left :. Left arrString 2 , Len arrString 2 - 1. Step 2: In the next step the numeric part is converted to a double value. FreeFile - Is used to supply a file number that is not already in use.

This is similar to referencing Workbook 1 vs. Workbook 2. By using FreeFile, the function will automatically return the next available reference number for your text file. Write - This writes a line of text to the file surrounding it with quotations. Chances are this post did not give you the exact answer you were looking for.

We all have different situations and it's impossible to account for every particular need one might have. In this article, I explain the best strategies I have come up with over the years to getting quick answers to complex problems in Excel, PowerPoint, VBA, you name it! One way to do that is using the FilesystemObject. Avoid using Select, Selection and Activate in your code.

Use With End With instead. Re: Clear data from text file Rudi - thank you for the clarification and the helpful contribution. Originally Posted by bakerman2. Kill will delete the file entirely and from what I understand you simply want to erase data, not delete files. Replies: 8 Last Post: , PM. Replies: 2 Last Post: , AM. Replies: 1 Last Post: , PM. Step 4: Run the above code from the run button provided or press F5 to get the following result.

We discussed about formatting earlier in the article. Do clear contents also clear the formatting of cells with the contents? We will see that in this example. For demonstration purpose, I have data in sheet 3 in Light Blue color. Have a look at it below,. Step 2: We know that in order to use the properties of sheet 3 we have to activate the worksheet by the following code. Step 3: We know that we have data in the cell range A1:C3 in sheet 3. We can see that the data from cell range A1:C3 has been cleared but the format of the cells is still intact.

In this example we have some data in sheet 4, the data is with bold and italic format. Once we have cleared the contents we will put back some data in those cells again to see if the formatting is present or not.

Step 2: We know that in order to use the properties of sheet 4 we have to activate the worksheet by the following code. Step 3: We know that we have data in the cell range A1:B1 in sheet 4.