May 26th, 2022

VBA 2010 – 099: GetOpenFilename

How to open a dialog box allowing the user to select files. This in turn is given to your code so that you can work with the selected files.
Download the samples for this series for free!

All our tutorial samples are free however if you appreciate our work and would like to make a voluntary donation then please do.

Recommended Reading

Both the below books by John Walkenbach are fantastic books and he is a brilliant author, I would recommend picking one of these books up even if just for a reference. I have read power programming cover to cover and it is easy to follow and is a must have for any serious VBA programmer.

If you have read any books and feel they are worth recommending then please post about them on our Forum.

VBA 2010 – 114: Creating a SQL file

VBA 2010 – 088: SQL JOINS

One Comment

  1. Omar Salinas
    August 19, 2016


    I have troubles to run the macro. I think its because I don´t configurate correctly the references en VBA.

    Actually, I´ve checked this references:

    Visual Basic for Applications
    Microsoft Excel 14.0 Object Library
    OLE Automation
    Microsoft Office 14.0 Object Library
    Microsoft ActiveX Data Objects 6.1 Library
    Microsoft ActiveX Data Objects Recordset 6.0 Library




Leave a comment

Your email address will not be published. Required fields are marked *