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
    1. Advertisements

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.
Similar Threads
  1. Gordon Filby
    Replies:
    4
    Views:
    142
    Gordon Filby
    Jul 7, 2003
  2. Rick Robinson

    Run Macro on Multiple Files in a Directory

    Rick Robinson, Jul 16, 2003, in forum: Word VBA Beginners
    Replies:
    2
    Views:
    179
    Jay Freedman
    Jul 16, 2003
  3. Petra Liverani

    Save as in current directory

    Petra Liverani, Aug 29, 2003, in forum: Word VBA Beginners
    Replies:
    2
    Views:
    159
    Petra Liverani
    Aug 30, 2003
  4. MRC

    INSERTING A DIRECTORY LISTING

    MRC, Feb 26, 2004, in forum: Word VBA Beginners
    Replies:
    2
    Views:
    126
    Jay Freedman
    Feb 27, 2004
  5. Pete

    Print documents in directory

    Pete, Feb 27, 2004, in forum: Word VBA Beginners
    Replies:
    1
    Views:
    96
    Word Heretic
    Feb 28, 2004
  6. Alan Silver

    How to set the character set when adding text in VBA

    Alan Silver, Jul 13, 2004, in forum: Word VBA Beginners
    Replies:
    0
    Views:
    161
    Alan Silver
    Jul 13, 2004
  7. Luká¹ Cyrankowski

    how to delete files from a directory using VBA

    Luká¹ Cyrankowski, Nov 2, 2005, in forum: Word VBA Beginners
    Replies:
    3
    Views:
    185
    Karl E. Peterson
    Nov 4, 2005
  8. WayneK

    VBA to Show Directory of Doc Files

    WayneK, Aug 19, 2006, in forum: Word VBA Beginners
    Replies:
    1
    Views:
    142
    Jonathan West
    Aug 20, 2006
Loading...