View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Selecting a default path/directory

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




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?