Can the user "Choose" the path via a VBA command?You can put up the
directory selection dialog:
http://j-walk.com/ss/excel/tips/tip29.htm
How to select a directory
found at John Walkenbach's site.
--
Regards,
Tom Ogilvy
"Brad Patterson" wrote in message
...
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 ?