| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
File Dialog Folder Picker open to particular folder
I'm currently using "Application.FileDialog(msoFileDialogFolderPicker) .Show" to have the user open a folder. When that dialog pops up, it automatically opens to the last folder that was opened. I'd like it to always open to the same root folder, so the user can select the correct folder from there. Is there a way to specify this? I've tried putting a change directory command before the file dialog code, but that didn't do anything.
Just fyi: All of my folders are on a network path. I usually use this to nativate to my network path: Code:
Sub ChDirNet(szPath As String)
Dim lReturn As Long
lReturn = SetCurrentDirectoryA(szPath)
If lReturn = 0 Then Err.Raise vbObjectError + 1, "Error setting path."
End Sub
'Use this when I want to change directories in my code:
ChDirNet("my file path")
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
File Dialog Folder Picker open to particular folder
Keri,
Have you tried this? With Application.FileDialog(msoFileDialogFolderPicker) .InitialFileName = "C:\Desktop" .Show End With |
|
#3
|
|||
|
|||
|
Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find file in folder and sub-folder and sub-folder and sub-folderand etc... | Excel Programming | |||
| Open Folder dialog box | Excel Programming | |||
| Check for file in folder, if not there, open folder to rename file | Excel Programming | |||
| Save file in a new folder, but create folder only if folder doesn't already exist? | Excel Programming | |||
| open file from folder save in new folder | Excel Programming | |||
Linear Mode
