+ Reply to Thread
Results 1 to 4 of 4

FileDialog() issue

  1. #1
    Forum Contributor
    Join Date
    04-24-2012
    Location
    Karlstad, Sweden
    MS-Off Ver
    Excel 2016
    Posts
    232

    FileDialog() issue

    Hi,

    I have a very strange issue with ".FileDialog()". Hopefully someone has encountered the same issue as myself with a solution. Maybe the issue came with change from Windows 7 to 10.

    Running Test below behaves differently in two different programs with exactly same code:
    * Program A - 'Folder Name' is Empty when form opens. Click OK by using default folder and everything works fine
    * Program B - 'Folder Name' is not empty when forms open (Here 'Drives' is written automatically. No idea why). Click OK by using default folder and an Error message is shown. See attached Picture.

    Error seems to occur when program writes something in 'Folder Name' by default. I have no idea why it behaves differently. Any idea?

    Please Login or Register  to view this content.
    Attached Images Attached Images
    1. Reply to thread and inform if suggestion was helpful or not
    2. Click on the star (=Add Reputation) if you think someone helped you
    3. Mark [SOLVED] to this thread if solution was found. (On Menu "Thread Tools" > "Mark this thread as solved")

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2509 (Windows 11 Home 24H2 64-bit)
    Posts
    92,809

    Re: FileDialog() issue

    What do you mean by Program A and Program B? Are these different workbooks?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Volunteer organiser & photographer with the Sutton Hoo Ship's Company: https://saxonship.org/
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,488

    Re: FileDialog() issue

    Try including the backslash.

    Please Login or Register  to view this content.
    @AliGW, I believe program A and B refer to calling the function with and without the optional argument of StartUpFolder
    Cheers
    Andy
    www.andypope.info

  4. #4
    Forum Contributor
    Join Date
    04-24-2012
    Location
    Karlstad, Sweden
    MS-Off Ver
    Excel 2016
    Posts
    232

    Re: FileDialog() issue

    Add Path Separator worked fine.

    Thanks for your help.

    \Joakim

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] FileDialog Help
    By shrubfact in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 03-01-2017, 09:16 AM
  2. FileDialog
    By DaveInOhio in forum Outlook Programming / VBA / Macros
    Replies: 2
    Last Post: 11-25-2009, 12:18 AM
  3. using a filedialog box from a dll
    By Paul in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2006, 12:00 PM
  4. filedialog
    By Norm in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 AM
  5. filedialog
    By Norm in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  6. filedialog
    By Norm in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  7. FileDialog issue
    By cgc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-18-2005, 05:06 PM

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