I find the FileDialog
Application.FileDialog(msgFilePicker) with Microsoft Officer X.X Object library a bit easier to use and requires less code like shown in this video
https://www.youtube.com/watch?v=AO2-jgVu8V0
Is there a course where you learn to use the application.FileDialog?

---

Reply from Alex Hedley:

Nothing is coming back in the Search. I was sure I'd seen it in a video but maybe I'm mistaken.
Since it's VBA it hasn't been covered in any of the Expert Lessons, it'll likely be covered in the Advanced Series.

One mention I did find was in this Thread.


Dim FO As Object
Set FO = Application.FileDialog(3)
FO.Show
MsgBox "You selected: " & FO.SelectedItems(1)


Here's an extended Tip on how to use it.