Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    File Open (VBA Office 2K)

    Good afternoon folks
    Some time back I stumbled across a snippet of code that someone posted which was the equivalent of using File/Open from the menu bar in Word or Excel. Like Word the code presented a graphic of the folder tree; allowing the user to browse. If someone recalls the post and can pointy me to it, i will be most grateful.
    Regards
    Don

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: File Open (VBA Office 2K)

    If you want to let the user select a folder, you may mean <post#=271140>post 271140</post#>.

    If you want to let the user open a file, you can use <code>Application.Dialogs(wdDialogFileOpen).Show </code> in Word, or <code>Application.Dialogs(xlDialogOpen).Show</code> in Excel.

  3. #3
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: File Open (VBA Office 2K)

    Thank you Hans, you have anticipated my eveery need.
    Regards
    Don

Posting Permissions

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