Yes, it is. Thanks.

"Tom Ogilvy" wrote in message
...
It allows you to choose the folder - just like you asked.

There is no reason that I can see to set a starting directory as you
described you problem. You want to select a directory and it allows you
do
to that.

the link at the bottom would be started as
http://www.bmslt.ie

but as I said, you don't need to specify a starting directory.

there is a new object called filedialog in excel 2002 and later, but then
anyone using the code would need to have xl2002 or later.

the code isn't complex since it already has been written and all you need
to
do is paste it into a new module. How complex is that?

--
Regards,
Tom Ogilvy



"Grace" wrote in message
...
OK, I went there. At the bottom, it says:

NOTE:
If you use Excel 2002 you can prompt the user to select a directory by
using
the new FileDialog object. The advantage is that you can specify a
starting
directory.

Does this mean that with newer versions of EXCEL (2002 and newer), there
is
a much easier way? His way looks quite complex.

Also, if there is not a much easier way, I note that that site says
Specifying the starting directory
If you would like to be able to specify the starting directory, things get
a
lot more complicated.
Download Jim Rech's BrowseForFolder example
But that link is no longer working. Also, I am confused about what the
first macro does. Does it just tell you what the current directory is,
but
doesn't allow you to "specify" the one you want? If so, and if the bottom
link doesn't work, I am still out of luck.


Help, anyone!

Grace
"Tom Ogilvy" wrote in message
...
http://j-walk.com/ss/excel/tips/tip29.htm
Selecting a Directory

--
Regards,
Tom Ogilvy


"Grace" wrote in message
...
My subroutines open up a lot of files with very specific names. I
will
be
careful to give those files the right names before starting the macro.

One thing I'm having trouble with is telling it the right path and
folder
to
look in. Though I could try to automate the pathname too, I am
starting
to
think that it would be just best to have the macro let me browse to
the
folder, WITHOUT even opening a file. can someone suggest some VBA
code
to
have it let me browse to a folder and then set that folder as the
default
place to look for any files I am to LATER open, even the very first
one.

Thanks,
Grace