specifing default folder with GetOpenFilename
Brian,
Use ChDrive and ChDir,
ChDrive "C:\"
ChDir "C:\"
--
HTH
Bob Phillips
"Brian" wrote in message
...
I'm am using the GetOpenFilename method to allow a user to
pick a spreadsheet to open. This is to by-payss the
enable/disable macro option. I want to start the user in
a specific network folder(instead of their
defaultfilepath). Is there a way to do this?
I have tried the Application.DefaultFilePath = ("xxxx")
but this only changes the default folder the next time the
user accesses the the system and not the current instance.
Thanks,
Brian.
|