Selecting a default path/directory

[shumwaymeister]

I am writing some VBA code to set the default path/directory. I was
wondering if there was an API to do this.

There's an API to select a file from a specific directory, namely
'Application.GetOpenFilename'. I am assuming there is a function or a
series of functions to select a path/directory, without having to parse
the output from 'Application.GetOpenFilename'.

Ideas?

 

[Jim Cone]

Application.DefaultFilePath ?
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



<[email protected]>
wrote in messageI am writing some VBA code to set the default path/directory.
I was wondering if there was an API to do this.

There's an API to select a file from a specific directory, namely
'Application.GetOpenFilename'. I am assuming there is a function or a
series of functions to select a path/directory, without having to parse
the output from 'Application.GetOpenFilename'.
Ideas?