+ Reply to Thread
Results 1 to 6 of 6

Open folder with "Application.dialogs(xldialogopen).show" not showing all files ?

  1. #1
    Registered User
    Join Date
    02-06-2013
    Location
    Pretoria
    MS-Off Ver
    Excel Latest Version
    Posts
    11

    Smile Open folder with "Application.dialogs(xldialogopen).show" not showing all files ?

    Hi All,

    I'm using a macro to open a specific folder using "ActiveWorkbookPath" and it opens the dialog box showing "All Excel Files".
    I need it to show "All Files" and not just exel file types, and preferably not showing the navigation pane on the left.

    Can anyone help me with the right arguments to achieve this Pleassse? :-)

    My sample code look like this:

    Please Login or Register  to view this content.
    This is the default view I get:

    FoldertestPic1.png

    And this is the view I would like to get..

    FoldertestPic2.PNG

    Thanks in advance :-)
    All help appreciated
    Last edited by arlu1201; 03-14-2013 at 03:51 AM. Reason: Use code tags in future.

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Open folder with "Application.dialogs(xldialogopen).show" not showing all files ?

    Please Login or Register  to view this content.
    If solved remember to mark Thread as solved

  3. #3
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Open folder with "Application.dialogs(xldialogopen).show" not showing all files ?

    Hi, patel45,
    Quote Originally Posted by ChrisBester
    I need it to show "All Files" and not just exel file types
    *.xls* is for Excel-Files, *.* should be for all files.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  4. #4
    Registered User
    Join Date
    02-06-2013
    Location
    Pretoria
    MS-Off Ver
    Excel Latest Version
    Posts
    11

    Re: Open folder with "Application.dialogs(xldialogopen).show" not showing all files ?

    Thanks for the effort Patel, if I change the "/*xls*" to "/*.*"
    it kinda works. It shows all files in the dialog box although it still says "All Excel Files" in the foldertype box in the bottom right corner.

    It does not solve my problem not to show the navagation pane on the left side though.

    But thanks again :-)

  5. #5
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Open folder with "Application.dialogs(xldialogopen).show" not showing all files ?

    the navigation pane option is not exposed in vba. to change the file types you can use
    Please Login or Register  to view this content.
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  6. #6
    Registered User
    Join Date
    02-06-2013
    Location
    Pretoria
    MS-Off Ver
    Excel Latest Version
    Posts
    11

    Re: Open folder with "Application.dialogs(xldialogopen).show" not showing all files ?

    Thanks a lot JP, that worked Modified it slightly to drop down one level from my active path as shown below and it gives the result I wanted.

    .InitialFileName = ThisWorkbook.Path & "\Second level\"

    Thanks guys for all the input

    Cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1