Set a suggested directory with vba from access

Discussion in 'Word VBA Beginners' started by Slickdock, Oct 21, 2010.

  1. Slickdock

    Slickdock Guest

    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
    Slickdock, Oct 21, 2010
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.