Category Archives: File and Folder Dialog

No Thumbnail

VBA, Check If Text File is Open

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

No Thumbnail

Word VBA, Modify Header For Multiple Files

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

No Thumbnail

Excel VBA Open File Dialog

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

No Thumbnail

File and Folder Dialoges VBA

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.