I would recommend that you respect the user's settings and restore the
Current Directory after the GetOpenFilename
Dim OldDir As String
Dim FName As Variant
OldDir = CurDir
ChDrive "C:\Test"
ChDir "C:\Test"
FName =Aplication.GetOpenFilename(....)
ChDrive OldDir
ChDir OldDir
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
wrote in message
ups.com...
On 27 Feb., 09:44, "NickHK" wrote:
Brun,
You can use ChDrive/ChDir before the call to .GetOpenFilename to point to
the desired location.
NickHK
wrote in message
oups.com...
Hi all
I have a question to Excel VBA.
I am using the GetOpenFilename application to open the "open file"
browser. It automatically starts browsing the last place I have saved
or downloaded a file. I am using the GetOpenFilename in the following
way:
fileToOpen = Application.GetOpenFilename("Inflow Files (*.flo),
*.flo,All Files (*.*), *.*")
My question is:
How do I specify the path for where I wan't to browse from? Is it
Application.path??? something I have to change before I run the
GetOpenFilename command?
Any help appreciated.
Regards
Brun- Skjul tekst i anførselstegn -
- Vis tekst i anførselstegn -
Off cause. Works perfect. Thankyou.
Brun