xlDialogSaveAs - default file name
Eliminate Pivot Table Annoyances
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: xlDialogSaveAs - default file name

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Brian Branch
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    In a macro I'm using the following text:

    Application.Dialogs(xlDialogSaveAs).Show

    to bring up the Save As dialog box. I'd like to suggest a file name to the user when the box pops up. Do you know if there's a way to do this?

    Also - how about the path the Save As box shows?

    -thanks


  2. #2
    New Member
    Join Date
    Apr 2002
    Location
    Milwaukee, WI
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Try using the Application.GetSaveAsFileName method. The help file will tell you the exact syntax.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com