How to Select and Open Files in VBA: Complete Guide to Application.GetOpenFilename and Workbooks.Open

One of the most common tasks in Excel automation is allowing users to select a file and then opening that file through VBA. Whether you are importing CSVs, consolidating monthly reports, processing external datasets, or building professional tools for your organization, understanding how to let users choose a file safely and how to open it programmatically is essential.

Two VBA functions form the foundation for this task:

• Application.GetOpenFilename — prompts the user to select a file
• Workbooks.Open — opens the selected file for processing

Using these together lets you build flexible file import tools, user-friendly automation workflows, and structured processes that integrate smoothly with RPA solutions like UiPath or Power Automate.

This guide explains how both features work, how to combine them, and how to apply them in real-world automation scenarios.

---

✅ Understanding How to Select and Open Files in VBA (GetOpenFilename + Workbooks.Open)

・What GetOpenFilename does

Application.GetOpenFilename displays the standard file selection dialog, similar to what Excel users see when choosing a file manually.
It does not open the file; it simply returns the selected file path as a string.

・What Workbooks.Open does

Workbooks.Open opens a workbook from a supplied file path.

・Why they are used together

You first ask the user to choose a file, then open that file in VBA.

---

✅ How to Use Application.GetOpenFilename to Select a File

・Basic syntax (Syntax: GetOpenFilename)

Application.GetOpenFilename

This shows a simple dialog, but normally we supply filters and custom titles.

・Selecting a file with filters

filePath = Application.GetOpenFilename("Excel Files (*.xlsx), *.xlsx")

・Selecting any file type

filePath = Application.GetOpenFilename("All Files (*.*), *.*")

・Adding a title for clarity

filePath = Application.GetOpenFilename( _
FileFilter:="Excel Files (*.xlsx), *.xlsx", _
Title:="Select a file to open")

・Checking if the user clicked Cancel

If Cancel is pressed, the function returns False, not an empty string.

If filePath = False Then
MsgBox "No file selected."
Exit Sub
End If

This is essential for preventing runtime errors.

---

✅ How to Use Workbooks.Open to Open a File

・Basic syntax (Syntax: Workbooks.Open)

Workbooks.Open filePath

・Opening a file as read-only

Workbooks.Open filePath, ReadOnly:=True

・Opening a password-protected workbook

Workbooks.Open filePath, Password:="mypassword"

・Opening a CSV file

Workbooks.Open "C:\Data\Sales.csv"

・Closing the file after processing

Workbooks(fileName).Close SaveChanges:=False

---

✅ Combining GetOpenFilename and Workbooks.Open (Most Common Pattern)

・The complete pattern (Example: Select and open a file)

Sub SelectAndOpenFile()
Dim filePath As Variant
filePath = Application.GetOpenFilename( _
FileFilter:="Excel Files (*.xlsx), *.xlsx", _
Title:="Select a workbook to open")
If filePath = False Then
MsgBox "Operation cancelled."
Exit Sub
End If
Workbooks.Open filePath
End Sub

This is the core technique used in most professional tools.

---

✅ Practical Examples of Selecting and Opening Files

Below are real-world examples designed for business automation, reporting, and RPA workflows.

---

・Example 1: Select any Excel file and open it

Sub OpenSelectedExcelFile()
Dim fp As Variant
fp = Application.GetOpenFilename("Excel Files (*.xls*), *.xls*")
If fp = False Then Exit Sub
Workbooks.Open fp
End Sub

---

・Example 2: Select a CSV file and open it

Sub OpenCSV()
Dim fp As Variant
fp = Application.GetOpenFilename("CSV Files (*.csv), *.csv")
If fp = False Then Exit Sub
Workbooks.Open fp
End Sub

---

・Example 3: Select multiple files (multi-select enabled)

Sub OpenMultipleFiles()
Dim files As Variant
Dim i As Long
files = Application.GetOpenFilename( _
FileFilter:="Excel Files (*.xlsx), *.xlsx", _
MultiSelect:=True)
If IsArray(files) = False Then Exit Sub
For i = LBound(files) To UBound(files)
Workbooks.Open files(i)
Next i
End Sub

This is perfect for consolidating monthly reports or sales files.

---

・Example 4: Open a file and copy data to the current workbook

Sub ImportData()
Dim fp As Variant
Dim wb As Workbook
fp = Application.GetOpenFilename("Excel Files (*.xlsx), *.xlsx")
If fp = False Then Exit Sub
Set wb = Workbooks.Open(fp)
wb.Sheets(1).Range("A1").CurrentRegion.Copy _
ThisWorkbook.Sheets("Data").Range("A1")
wb.Close SaveChanges:=False
End Sub

This approach is widely used in business automation routines.

---

・Example 5: Select a file for UiPath preprocessing

Sub PrepareForUiPath()
Dim fp As Variant
fp = Application.GetOpenFilename("Excel Files (*.xlsx), *.xlsx")
If fp = False Then Exit Sub
Dim wb As Workbook
Set wb = Workbooks.Open(fp)
wb.Sheets(1).UsedRange.ClearFormats
wb.Close SaveChanges:=True
End Sub

UiPath bots perform better when files are clean and predictable.

---

✅ Advanced Techniques Using GetOpenFilename and Workbooks.Open

・Filtering by multiple file types

"Excel Files (*.xlsx; *.xlsm), *.xlsx; *.xlsm"

・Building a custom filter set

FileFilter:="Excel (*.xlsx), *.xlsx, CSV (*.csv), *.csv"

・Defaulting to a specific folder

ChDir "C:\Reports"
filePath = Application.GetOpenFilename(...)

・Selecting a file programmatically without user interaction

filePath = "C:\Data\Input.xlsx"
Workbooks.Open filePath

・Extracting the file name from the path

fileName = Dir(filePath)

---

✅ Error Handling When Selecting or Opening Files

・Handling Cancel correctly

If selectedFile = False Then Exit Sub

・Handling files that cannot be opened

On Error GoTo Failed
Workbooks.Open fp
Exit Sub
Failed:
MsgBox "Unable to open the file. It may be locked or corrupted."

・Handling network path issues

If files are in shared drives, ensure path reliability.

・When using UiPath

File locks can occur if UiPath or Excel is already opening the file.
Using Try/Catch blocks in the RPA flow ensures smooth execution.

---

✅ Choosing Between GetOpenFilename and FileDialog

Application.GetOpenFilename is:

• Simple
• Fast
• Reliable
• Suitable for most automation

FileDialog is:

• More customizable
• Supports folder selection
• Allows multi-selection with better UI

Both methods are valid depending on the workflow.

---

✅ Best Practices for File Selection and Opening in VBA

・Always check for Cancel

Avoid runtime errors.

・Always use explicit workbook references

Avoid relying on ActiveWorkbook.

・Close files when done

Prevent memory leaks and unwanted Excel sessions.

・Use filters to guide users

This reduces errors.

・For RPA workflows

Ensure files open in a consistent, clean state.

・Avoid hard-coded paths when user input is needed

Let the user choose, especially for shared environments.

---

✅ Real Business Use Cases for File Selection + Opening

・Data consolidation

Users select multiple files for merging.

・Report import tools

Daily, weekly, or monthly reports loaded on demand.

・Template-driven input flows

Users select a template file that automation will populate.

・Financial modelling

Users choose scenario files, model versions, or updated forecasts.

・RPA integration

UiPath workflows often rely on VBA preprocessing before automation begins.

・Large dataset loading

CSV, TXT, and Excel files imported cleanly into structured worksheets.

---

✅ Summary：Mastering File Selection and Opening Enables Flexible, User-Friendly VBA Automation

• Use Application.GetOpenFilename to let users choose files safely.
• Use Workbooks.Open to open files programmatically.
• Combine both for flexible, powerful import tools.
• Implement Cancel handling to avoid runtime errors.
• Use filters to guide user choices and prevent mistakes.
• Apply multi-file selection for consolidation workflows.
• Optimize file handling for RPA tools such as UiPath and Power Automate.
• Use advanced techniques like dynamic paths, SaveCopyAs, and error management.

Once you master file selection and opening logic, you can build highly interactive, user-friendly Excel VBA tools that adapt to real business workflows and automate complex data processes efficiently.