Category Archives: File and Folders

Excel VBA: Display File Name as Hyperlink

In this article we will show you how to display file name as a hyperlink to a file in Excel. We first introduced this concept in this article but will expand upon it here. For this we will use the Hyperlinks.Add Method. Let’s have a

The GetOpenFilename Command in VBA

How often in your VBA code do you have ask for a file name along with its complete path as an input from the user? Most programmers end up using an input box in this situation. However, this is not very convenient for the user. Furthermore, there are

Using Application.Filedialog in Microsoft Excel VBA

What is the Application.FileDialog VBA function and how do you use it? Basically, it returns a FileDialog object instance of the dialog. This is similar to the functionality of the standard Open and Save dialog boxes found in Microsoft Office applications. Using these dialog boxes, users

The Excel VBA Application.FileDialog Object

Have you ever wished you could develop a simple way for users to select files to open from within Excel? Perhaps you want to impose a level of control over which file path users select the file(s) from. This can be done by using the

No Thumbnail

VBA, Modify Existing Text File

In this article I will explain how you can modify an existing text file. Jump To: Example 1, Overwrite Existing File With New Data Example 2, Modify Values in Text File Example 3, Adding Open and Save File Dialogs You can download the file and code related

No Thumbnail

VBA Folder Dialog

The folder dialog is a dialog that prompts the user to select a directory path. Jump To: Example Button Name, ButtonName Change Title, Title Start Path, InitialFileName You can download the file and code for this file here. Please note that although the sample file is for

No Thumbnail

VBA Excel, Writing to a Text File

In this article I will explain how you can create a text file and how write data to a text file in overwrite and append modes. Jump To: Create a Text File Example 1, Write One Line of Data to Text File Example 2, Write Multiple

© Copyright 2018