Results 1 to 20 of 39

Thread: Solved: Allow users to set default save directory.

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Master
    Joined
    Jun 2006
    Posts
    1,091
    Location

    Solved: Allow users to set default save directory.

    I want to create a text box where my users can save a default save directory. and when the save as dialog comes up within my program it opens up in that dialog. is this possible?

    I already know how to save it to a registry setting but how do I open the save as dialog into that folder?

    [VBA]If Not Application.Dialogs(xlDialogSaveAs).Show(, 1) Then
    MsgBox "The Report did not Save."
    End If[/VBA]
    Last edited by Djblois; 04-27-2007 at 10:08 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •