I have a partial answer - and a new question for someone
out there!

You can use the Application.DefaultFilePath property to
set the default file path for Excel.

Application.DefaultFilePath = "k:\folder1\folder2\PTI" &
Sheets("Sheet1").Range("A1")

You could put this in the Workbook_SheetChange() event so
that it gets reset anytime your range value is changed.

NOW THE QUESTION:

When using the Application.DefaultFilePath, I am finding
that Excel does not seem to change the path right away.
If I set the property to a new value and then do a File
Open, I get the prior file path (from where the latest
workbook was opened). I have to actually select and open
a file (Canceling does not change anything); then the NEXT
time I use File Open I get the new folder I specified as
the DefaultFilePath.

What gives?

K Dales

-----Original Message-----

This one probably isn't as hard as I'm making it out to
be...

Lets say I have a cell, a1, on sheet1 that contains
text. now lets say
i want the filename to be PTI and then the text from that
cell. In
excel speak that would be "PTI"&sheet1!a1 , if i am not
mistaken. I
want that filename to be the default one in the dialog
box, so we don't
have to type it in everytime.

It would be really nice if I could also figure out how to
make a
specific folder on a specific drive the default path
instead of My
Documents.

So the final filename would look like:

k:\folder1\folder2\PTI[text from sheet1!a1]

Then all i would have to press is save, unless i wanted
to change it.
but since that is what it will be 99% of the time, that
is how i want
it.

If anyone thinks they have a handle on this one, I'd
appreciate some
guidance.

Thanks


--
jacksonz
----------------------------------------------------------
--------------
jacksonz's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=13728
View this thread:
http://www.excelforum.com/showthread...hreadid=262475

.