• Bring up File/Find Dialog (Excel 2000)

    Author
    Topic
    #383454

    Hi all,

    Using VBA, is it possible to bring up the File/Look In Dialog and return the path? In VBA I have hard coded a text file to open and write certain parts of it to an Excel spreadsheet and would like to make it more file specific/user friendly where the user can select the file manually (at this point!). Something similar to the gif below…

    Viewing 0 reply threads
    Author
    Replies
    • #653984

      Thanks anyway, I found it in the help file using Application.GetOpenFilename. Have a great day!

    Viewing 0 reply threads
    Reply To: Bring up File/Find Dialog (Excel 2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: