Search code examples
excelexcel-2003fileopendialogvba

Browse for a File from Excel VBA

How can I put up a "File Open" dialog from some VBA running in Excel?

I'm using Excel 2003.

Solution

  • You want the Application.GetOpenFilename function. Copying from VBA Object Browser:

    Function GetOpenFilename([FileFilter], [FilterIndex], [Title], [ButtonText], [MultiSelect])
    Member of Excel.Application