In this article I will explain how you can read the values in a text file and print them in columns in Excel. For example lets say we have the following data in a text file: We want to read the data from the text
In this article I will explain how you can use VBA for word to open multiple files and modify them. – Step 1: Put all the word documents that you want to modify in one folder. Note the file with the VBA code should be
Previously in the article Find and List all Files and Folders in a Directory I’ve explained how you can use VBA to find and list all the files and folders in a specific directory. In this article I will explain how you can do the same, only
When you are working with text files, it is a good idea to check for errors when opening the file. Without the proper error handling the program might terminate unexpectedly. The file and code related to this article can be downloaded here. Below are a two reasons why the program
previously in the article below I’ve explained how you can modify multiple word files: Word VBA, Apply Macro to Multiple Files In this article I will explain how you can extend that concept to modify the header of multiple word files using VBA. – Header
There may be times when you need to ask the user to select a file to open. This can be done using the open file dialog. Keep in mind that the open file dialogs doesn’t actually open anything. It returns the path of the file
You have probably worked with file and folder dialogues before. Selecting a file to open choosing a path to save the current file choosing a directory path Although it would seem that the dialog itself does the saving and opening, but most dialogues actually don’t do any of that.