Results 1 to 5 of 5
  1. #1
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    254
    Thanks
    6
    Thanked 1 Time in 1 Post

    Get File Directory Name (VBA/Excel/2000)

    I have a bunch of files. The number varies from time to time. Instead of opening them all at once, I want my module to open a built-in dialog (or a custom dialog if that is easier) and allow the user to select the files. The code would write their names & path to an array and then I would step thru them doing everything else I need to do to them.

    I cannot find the syntax for capturing the file names and the path. <img src=/S/help.gif border=0 alt=help width=23 height=15>
    Alan

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Get File Directory Name (VBA/Excel/2000)

    If you search this Forum there's plenty of discussion. FWIW, there's code that I 'appropriated' in this <!post=post,400342>post<!/post> that does nicely.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    3 Star Lounger Jim Cone's Avatar
    Join Date
    Feb 2002
    Location
    Portland, Oregon, USA
    Posts
    238
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Get File Directory Name (VBA/Excel/2000)

    Alan,

    I think maybe, John posted the wrong link?
    Have you tried the "GetOpenFilename" method with the MultiSelect argument set to true?

    Regards,
    Jim Cone
    San Francisco, CA

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Get File Directory Name (VBA/Excel/2000)

    No, I overlooked that the post was about Excel. <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30> There's no GetOpenFilename equivalent in Outlook, so I had to use all that stuff to do some tapdancing I wanted within Outlook. GetOpenFileName is much simpler; Legare's post in <!post=this thread,315059>this thread<!/post> should get Alan started.
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    254
    Thanks
    6
    Thanked 1 Time in 1 Post

    Re: Get File Directory Name (VBA/Excel/2000)

    Thanks to everyone.

    I found a snippet of code I wrote a year ago where I had already "invented the wheel."
    Alan

Posting Permissions

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