VBA File Selection Window to Open Files in Excel

Add to Favorites
Author: | Edits: don

Make a file selection browser in Excel using VBA/Macros - this is the file window that allows a user to browse their computer and select a file to open or do something else with.

This tutorial includes two separate examples and macros and is part of a much larger premium course for VBA/Macros on TeachExcel.com.

The two macros that will be covered here include:

  • how to create a simple file selection window in Excel
  • how to apply file type filters to the file selection window so that the user will only see the file types that they should be able to select.

The tutorial also includes a File Filter Syntax Cheat-Sheet that shows you exactly how to make your own file filters, and this is in addition to my explaining how to make these filters in the tutorial itself.

The second example in this tutorial includes a more formal, or proper, example of creating a macro, whereas the first example is a barebones example that will get you started.

In addition to the above mentioned features, I will also show you how to prevent the macro from doing anything else if the user does not select a file and how to show the user a message if they do not select a file.

I hope you enjoy this tutorial and find it helpful!


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Similar Content on TeachExcel
Copy Data or Formatting to Multiple Worksheets in Excel
Tutorial: Quickly copy all or parts of a single worksheet - data, formatting, or both - to multiple...
How to Add Boxes, Buttons, Arrows, Speech-Bubbles, Hearts, and More to a Spreadsheet in Excel
Tutorial: In this tutorial I am going to cover inserting and editing Shapes in an Excel workbook, as...
Add a Drop Down Menu to a Cell in Excel - Data Validation Macro
Macro: Add a drop down menu or list to a cell in Excel with this free Excel macro. This is a grea...
Easy Way to Manage Names in Excel
Tutorial: How to manage Names in Excel so they are easy to view and change as needed. This is a li...
How to Use Dates in Excel
Tutorial: Introduction Guide to using Dates in Excel - this tutorial will show you how to input and...
Make a UserForm in Excel
Tutorial: Let's create a working UserForm in Excel. This is a step-by-step tutorial that shows you e...