Edit text file using vbs

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!

I highly recommend that you check this guide out before asking me or anyone else in the comments section to solve your specific problem. I can guarantee 9 times out of 10, one of my strategies will get you the answer s you are needing faster than it will take me to get back to you with a possible solution. I try my best to help everyone out, but sometimes I don't have time to fit everyone's questions in there never seem to be quite enough hours in the day!

Next we reopen our file for writing , call the WriteLine method to write the contents of strNewText to the file, and then close the file a second time. The net effect? If we started off with a text file that looked like this:. As for doing this all from the command-line, we simply need to modify the script so that it will accept — in this order — three command-line arguments: the name of the file to open; the text we want to search for; and the text we want to replace.

Note that we store the command-line arguments in the variables strFileName, strOldText, and strNewText, and we use those variables when opening and saving the text file and when calling the Replace function:. Arguments 2. Comments are closed.

The script is something that we use to configure TSM backups. The script as written works fine under Server , but we are in the process of updating all of our servers to , and we have retro-fitted most of the script to work under the new environment. The only thing we are having issues with is editing a specific file. Apperault, is that your entire script? My guess is that it's just a part of it, and that you have an On Error Resume Next statement somewhere which is hiding the error that occurs when you try to write to a folder under Program Files.

Recent versions of Windows don't like that. Try commenting out the On Error Resume Next if you find one, and then see if the script gives a more specific error message. I think the commented code was just for testing since the variables match the function's parameters.

After reading the file's contents output strText to WScript. Echo or a MsgBox to make sure the variable contains the file contents and has the text you are looking for. Please note that although the code is written in an Excel file, it is applicable to all MS Office products.

When you open a text file and modify its content, although it may seem you are modifying its content but you are actually creating a new text file and overwriting the previous file. Basically what happened in the code above was that a new text file was created and the previous text file was overwritten with new data:.

Although it seems we are modifying the original file but we are actually overwriting the original file with a new file. The line below opens the text file for reading:. Open "D:TempTest. The code below loops through the text file until the last line is reached:. The line below reads the current line of the text file and stores it in the variable strLine :.

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.