Is there a way to include a path (S:\A\B\C\D) in GetOpenFilename so users don't have to work their way down to the appropriate directory to select a file?
Thanks in advance for your help.
Elaine
GetOpenFilename
Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.
-
-
Re: GetOpenFilename
Quote from ElaineIs there a way to include a path (S:\A\B\C\D) in GetOpenFilename so users don't have to work their way down to the appropriate directory to select a file?
Thanks in advance for your help.
ElaineElaine
Look up
ChDrive
ChDirAlso remember to restore current Directories back to what they were.
-
Re: GetOpenFilename
Hi Elaine
With reference to Ivan's reply above, I've recently used the following code . Hope it helps.
Code
Display MoreChDrive "c:\" ChDir "c:\APPS\NIS" NewFN = Application.GetOpenFilename(FileFilter:="Excel Files (*.xls), *.xls", Title:="Please select a file") If NewFN = False Then ' They pressed Cancel MsgBox "Stopping because you did not select a file" Exit Sub Else Workbooks.Open Filename:=NewFN End If
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!