Defaulting a folder for FileDialog in VBA

by

Add the folder path (including the trailing \) to InitialFileName. For example, to open the dialog in the user’s home directory do: 

f.InitialFileName = Environ("USERPROFILE") & "\"

If you forget the trailing \,
then the dialog box will still open in the correct folder,
but the folder name will also appear as the default selected file name.
Then the dialog will be looking for a sub-folder with the same name, which usually doesn’t exist.

I tried ChDir “your\path\here” and it works

More Related Contents:

  1. Loop through files in a folder using VBA?
  2. Wait for Shell to finish, then format cells – synchronously execute a command
  3. How can Excel VBA open file using default application
  4. Run same excel macro on multiple excel files
  5. how to detect whether VBA excel found something?
  6. VBA : save a file with UTF-8 without BOM
  7. Excel tab sheet names vs. Visual Basic sheet names
  8. Excel VBA “Method ‘Document’ of object ‘IWebBrowser2’ failed”
  9. Determine if cell contains data validation
  10. VBA – Range to jpg picture
  11. Sheet protection: UserInterFaceOnly gone
  12. Making VBA Form TextBox accept Numbers only (including +, – and .)
  13. VBA Convert date to week number
  14. Inserting an Online Picture to Excel with VBA
  15. Change length of For loop while in the loop
  16. VBA – Run Time Error 1004 ‘Application Defined or Object Defined Error’
  17. Consolidating worksheets into one
  18. Add a “CC recipient” to Outlook 2010 VBA
  19. How do I sort a collection?
  20. TextJoin UDF For Excel 2013
  21. Open an Excel file from SharePoint site
  22. Add new row to excel Table (VBA)
  23. Pass a parameter into an access report programmatically
  24. How do I open a file if I only know part of the file name?
  25. Restrict Outlook Items by Date
  26. VBA recognizing workbook by partial name
  27. Remove double quotation from write statement in vba
  28. Meaning of .Cells(.Rows.Count,”A”).End(xlUp).row
  29. Where does Outlook store the VBA code files?
  30. Working with current open email

Leave a Comment