+ Reply to Thread
Results 1 to 9 of 9

Specific folder when opening windows popup folder selection with msoFileDialogFolderPicker

  1. 06-15-2015, 10:19 AM #1
    trizzo
    trizzo is offline
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Brazil
    MS-Off Ver
    Excel 2007 & 2013
    Posts
    268

    Specific folder when opening windows popup folder selection with msoFileDialogFolderPicker

    Hello,

    How can I change this code in order to point to a specific folder? It is opening on default windows I think, which is "Libraries\Documents", but, I want to change to another folder for example "C:/Test/CPU".

    I tried the following, including the InitialFileName, but it is not working.
    I tried with 
    Please Login or Register  to view this content.
    and 
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Thanks!
    Last edited by trizzo; 06-15-2015 at 10:23 AM.
    Reply With QuoteRegister To Reply
  2. 06-15-2015, 10:21 AM #2
    trizzo
    trizzo is offline
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Brazil
    MS-Off Ver
    Excel 2007 & 2013
    Posts
    268

    Re: Specific folder when opening windows popup folder selection with msoFileDialogFolderPi

    In fact what is weird is that when I run this code, on the first run it opens the "Libraries\Documents" folder but, when I run again, it opens the correct folder "C:\Test\CPU"
    Reply With QuoteRegister To Reply
  3. 06-16-2015, 07:17 AM #3
    trizzo
    trizzo is offline
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Brazil
    MS-Off Ver
    Excel 2007 & 2013
    Posts
    268

    Re: Specific folder when opening windows popup folder selection with msoFileDialogFolderPi

    Can anyone help me please? Thanks!
    Last edited by trizzo; 06-18-2015 at 08:04 AM.
    Reply With QuoteRegister To Reply
  4. 06-18-2015, 09:42 AM #4
    trizzo
    trizzo is offline
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Brazil
    MS-Off Ver
    Excel 2007 & 2013
    Posts
    268

    Re: Specific folder when opening windows popup folder selection with msoFileDialogFolderPi

    Can anyone help me please? Thanks!
    Reply With QuoteRegister To Reply
  5. 06-18-2015, 10:34 AM #5
    nigelbloomy
    nigelbloomy is offline
    Valued Forum Contributor nigelbloomy's Avatar
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1,011

    Re: Specific folder when opening windows popup folder selection with msoFileDialogFolderPi

    I ran it like this and it worked. It did need the last "\" in the initial filename.

    Please Login or Register  to view this content.
    Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.

    <---Click * Add Reputation for all helpful comments. It's like giving a smile.
    Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.
    Reply With QuoteRegister To Reply
  6. 06-18-2015, 10:47 AM #6
    trizzo
    trizzo is offline
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Brazil
    MS-Off Ver
    Excel 2007 & 2013
    Posts
    268

    Re: Specific folder when opening windows popup folder selection with msoFileDialogFolderPi

    Thanks. By somehow it is working fine now for me!! Thanks!
    Reply With QuoteRegister To Reply
  7. 06-18-2015, 10:51 AM #7
    nigelbloomy
    nigelbloomy is offline
    Valued Forum Contributor nigelbloomy's Avatar
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1,011

    Re: Specific folder when opening windows popup folder selection with msoFileDialogFolderPi

    Oh good. The only time I got the Libraries/documents folder problem was when "C:\Test\CPU\" didn't exist on my computer. Once I changed it to a location that did exist it worked great.

    Glad it is working for you now. Sorry it took so long on here to get an answer. Good thing you bumped it back up today by posting a comment.
    Reply With QuoteRegister To Reply
  8. 06-18-2015, 11:03 AM #8
    trizzo
    trizzo is offline
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Brazil
    MS-Off Ver
    Excel 2007 & 2013
    Posts
    268

    Re: Specific folder when opening windows popup folder selection with msoFileDialogFolderPi

    I saw you also inverted this from:

    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.

    I think that is why it is working now for me. It was my bad! hehe
    Reply With QuoteRegister To Reply
  9. 06-18-2015, 11:05 AM #9
    trizzo
    trizzo is offline
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Brazil
    MS-Off Ver
    Excel 2007 & 2013
    Posts
    268

    Re: Specific folder when opening windows popup folder selection with msoFileDialogFolderPi

    Hey, I am trying to give you reputation, but it is saying: "You must spread some Reputation around before giving it to nigelbloomy again." I will do that as soon as I am able to do that. Thanks a lot!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA to show excel files inside a folder Application.FileDialog(msoFileDialogFolderPicker)
    By Paul Cherian in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-03-2014, 08:17 AM
  2. [SOLVED] Opening a Dialog Box for Folder Selection
    By Simon.Ward in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 01-22-2014, 07:24 AM
  3. Assign folder path from application.filedialog(msofiledialogfolderpicker) to a variable
    By mrt423 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2013, 05:01 PM
  4. [SOLVED] Saving a file to a specific name to a folder with a windows username
    By wagwagdude in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-07-2013, 06:13 PM
  5. Opening specific file or folder from Excel
    By goranm in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-12-2010, 08:53 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1