Excel File Picker VBA

Choosing a file with as an Excel file picker can be useful if you want to be able to pick a specific file to edit in a VBA procedure.

Tags excel, file, Dialog, picker, open, directory

During a procedure you may wish your user to choose a file to open. This can slow the process of running code down but if you have a moving target this will be essential in getting the right data imported or manipulated via VBA. I have not had to do this very often but a client asked if they could choose a file mid procedure and the following is what I came up with.

Tags Excel, VBA, File, Dialog, picker