+ Reply to Thread
Results 1 to 4 of 4

Save as window

Hybrid View

  1. #1
    Registered User
    Join Date
    03-27-2008
    Posts
    9

    Save as window

    I am looking to save three worksheets from one workbook as tab delimited text files into one folder. At the end of my macro I want to show the user the "Save As" window so the user can determine which folder to save all three text files into.

    What VBA language is needed to show the "Save as" window?

    Thanks in advance...

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481
    Have a look at

    
    application.GetSaveAsFilename
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    03-27-2008
    Posts
    9
    Thanks for that but found another alternative. Thanks.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    Please be courteous to the forum and explain your alternative.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1