Vba create .txt file

Use FSO to create the file and write to it. CreateTextFile strPath oFile. WriteLine "test" oFile. Improve this answer. Ben Ben Is using the Scripting Runtime preferred over the older channel method? I'd like some reasons to tell my students with info backed up by other experience. Please note that this answer promotes bad coding practice : The problem is that not explicitly defining the correct variable types as well as creating an object by a string reference to its name can cause you very hard to debug problems in the future for example if you misspell parts of the name.

Also, by not typing the variables, you have no way to learn about the other amazing methods FileSystemObject has to offer. Ben: Please consider updating your answer to lead beginners in a better direction. MarcusMangelsdorf I have heard you, but I don't want to have a debate. I disagree that this answer is promoting bad coding practice. Using late binding like this is perfectly acceptable and is useful where you don't know what version of the Microsoft Scripting runtime your user has on their machine.

Show 2 more comments. Open ThisWorkbook. Path property. Bhanu Sinha Bhanu Sinha 1, 10 10 silver badges 9 9 bronze badges. Pleas write the answer with some explanations and details. I prefer this method to the FSO method because it doesn't require external references and is quite short.

Although I do suggest using FreeFile to get the file number instead of hardcoding it as 1. I prefer this approach as well for mundane text file writing. Regarding comment from phrebh about using FreeFile instead of a hardcoded 1 see wellsr.

Show 1 more comment. To elaborate on Ben's answer : If you add a reference to Microsoft Scripting Runtime and correctly type the variable fso you can take advantage of autocompletion Intellisense and discover the other great features of FileSystemObject. WriteLine "something" ' Close it, so it is not locked anymore fileStream. The file was created! Marcus Mangelsdorf Marcus Mangelsdorf 2, 1 1 gold badge 29 29 silver badges 37 37 bronze badges.

Thanks for writing a complete answer with helpful comments to code. I'm more than happy if you learned something from my post! For this, we can use the free File function. Free File returns the unique number for the opened files.

This way, we can assign the unique file number without any kind of duplicate values. To determine which file number we are referring to, declare one more variable as Integer Variable As Integer In VBA, an integer is a data type that may be assigned to any variable and used to hold integer values. In VBA, the bracket for the maximum number of integer variables that can be kept is similar to that in other languages. Using the DIM statement, any variable can be defined as an integer variable.

Now we need to open the text file to work with it. Once the File is opened, we need to write something in it. Now, run the code this manually or through shortcut excel key Shortcut Excel Key An Excel shortcut is a technique of performing a manual task in a quicker way.

It will write the mentioned content in the mentioned text file. Step 1: With the continuation of the old example, define two more variables as Integer to find the last row and last column. Step 5: We need to loop through rows and columns, so declare two more variables as Integer. After the FOR statement, there is a criterion in this loop, and the code loops until the criteria are reached. Step 7: Now, to loop through columns, open one more loop inside the existing loop.

Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No. Any additional feedback?