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.

Example:
user opens \\serverA\form.xls
user alters the form
on save I need to change the default directory to
\\serverb\form1.xls

Any ideas?

Thanks
Steve