+ Reply to Thread
Results 1 to 2 of 2

Add Code to select a folder to save in

  1. #1
    Registered User
    Join Date
    09-24-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    19

    Add Code to select a folder to save in

    I have a workbook with several sheets. When the current code runs it will create .txt files. this all works fine the problem is they are saved in "My Documents" by default. I would like for the user to be asked which folder to save text files in maybe via: Input box or message box. Thanks for any help. This is the current working code.
    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    09-24-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: Add Code to select a folder to save in

    Problem Solved, just added these lines of code.

    Please Login or Register  to view this content.
    as well as modify open lines from
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    now the files will be saved in the same folder as the workbook with the macro.

+ 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