Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Bring up File/Find Dialog (Excel 2000)

    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...
    Attached Images Attached Images

  2. #2
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bring up File/Find Dialog (Excel 2000)

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •