I posted this question once before but asked the wrong question..

I am trying to change the Save As directory once a file is open so that
the user automaticly saves the file to a different directory than the
one they opened it in.

I am pulling a form from a document libary. The form then has to be
saved as a different name by the user to another directory. Each form
is saved as a different name by the user so I can not use the VBA code
to save worksheet as.

Is there any way to change the home directory for document once it has
been opened.


Thanks
Steve