Set a suggested directory with vba from access



I have a form in msaccess 2003 that has a textbox field [CaseFolder]
that contains a full path folder name.
I have msaccess code on that form that opens Word.

I would like, at that point, that when the users selects File->
Save...the suggested folder for saving will be the same as the
contents of [CaseFolder]. I DON'T WANT this code to change their
DEFAULT documents folder in Tools->Options-> File Locations. I just
want File, Save to behave as if it was the last folder accessed in
Word, so that SAVE suggests that [CaseFolder] folder.

Thanks in advance

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question