I have a template file that users open, which automatically runs a
script inside. The script runs a few SQL queries, formats up the
results, and then wants to save it out as a new file. Simple enough,
except...

How do I set the default file location? One would expect the path
would be part of the SaveAs, but no such luck!

And, more subtly, if the path does not exist, what do I do? I expect
most people will be opening this file from a particular machine, but
they *might* open it from a mapped drive on their own machines. I
would like to check to see if the default path exists, and if it
doesn't, default to Documents or similar.