I'm trying to assign my open dialog box to default to a specific folder on the network. Let's use the path:
Active5 years ago
![]()
Flowjo 10 mac cracked app. The code below doesn't work, but also doesn't error out. I can't figure out what I'm doing wrong.
I want to use Application.GetOpenFilename in Excel VBA to open a file and I want it to open in the same direc. Stack Overflow. Excel VBA change default directory for Application.GetOpenFilename. Use Application.GetOpenFilename in Excel VBA to open a file and I want it to open in the same directory as ThisWorkbook.Path. I have found. Sep 16, 2004 Set Path for GetOpenFilename. Discussion in 'Microsoft Excel Programming' started by Martin Los, Sep 16. This sets the specified Network Path as the Default. Then use Application.GetOpenFileName HTH. Setting the default path for GetOpenFileName. Set Path for GetSaveAsFilename. Set path for Application.Run.
Default File Path In Excel
I've seen a few ways people are doing this, but nothing seems to be working for me. I'm using excel 2010 if that helps.
My directory code:
How To Change Default File Path
Mike
What Is A File PathMikeMike
75744 gold badges1313 silver badges2929 bronze badges
2 Answers
I do not either get it to work using Jean-François Corbett
Application.FileDialog and SetCurrentDirectory . However, using the InitialFileName property and setting it to 'testyesno' (i.e. only specifying a path) does work.
29.5k2222 gold badges113113 silver badges165165 bronze badges
![]()
Kim HanssonKim Hansson
I'm able to open a dialog box using the following:
Getopenfilename Default File Pathway
Does this help? Can you please post the full macro?
StoriKnowStoriKnow
5,16433 gold badges2929 silver badges4040 bronze badges
File Path ReferencesNot the answer you're looking for? Browse other questions tagged excelvba or ask your own question.Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |