Tools Options General

Default File Location


-----Original 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


.