View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ian Gilmore Ian Gilmore is offline
external usenet poster
 
Posts: 1
Default Can the user "Choose" the path via a VBA command?

Brad Patterson wrote:
I wish to work in a directory chosen by a user.

At the moment, I can’t seem to get it to recognise the folder where the
user chooses a file with the “Application.GetOpenFilename” command. I
thought that this would be the easiest way, in that the user could
choose a file in the folder they wanted to work in and I’d change it
somehow – not so.

Any ideas ?


Look at the CHDIR command this will allow you change to the desired
directory prior to using GetOpenFileName command.