In A Sentence

business company

vbafasttrack.com provides the best Excel VBA courses, tutorials, tools and training. Period.


You are here:

Open File Dialog Box

Open File Dialog Box

Excel VBA code shows how to show the built in Excel File Open (or search for file) dialog box such that the user can make a file selection.


Sub GetFileNameFromUser()

Dim FN As String

FN = Application.GetOpenFilename("All files (*.*), *.*")

If FN = "FalseThen Exit Sub

'' Perform some other operations on the returned file iteslf as necessary ...

''Debug.Print FN

End Sub

This is another good example of using as much of the in built functionality of Excel as possible.

As Excel is battle-tested, been around for many years and has millions of users, you can be assured that the functions and other user-available operations both work well and work fast.



The best value Excel VBA course on the planet is here !



Great Trading Analysis

Worlds Best FX Bot