+ Reply to Thread
Results 1 to 4 of 4

Saving Excel Sheets into Specific Folder (inside same path)

  1. #1
    Registered User
    Join Date
    11-09-2016
    Location
    Cairo, Egypt
    MS-Off Ver
    2013
    Posts
    9

    Saving Excel Sheets into Specific Folder (inside same path)

    I am currently using the very simple vba code "ActiveWorkbook.SaveAs (strFilename2)" to save my file, how can I have that saved into the same path of the folder yet into a folder let's say for instance is "Summary"

    Thank you!

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MSO Home and Business 2024
    Posts
    7,283

    Re: Saving Excel Sheets into Specific Folder (inside same path)

    Post the complete code you are currently using to export and save your file.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  3. #3
    Registered User
    Join Date
    11-09-2016
    Location
    Cairo, Egypt
    MS-Off Ver
    2013
    Posts
    9

    Re: Saving Excel Sheets into Specific Folder (inside same path)

    Here you go! That's part of the code tho. Hope it helps

    Please Login or Register  to view this content.
    Last edited by jeffreybrown; 11-12-2016 at 10:58 AM. Reason: Please use code tags...Thanks!

  4. #4
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MSO Home and Business 2024
    Posts
    7,283

    Re: Saving Excel Sheets into Specific Folder (inside same path)

    Maybe like this.

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Get Folder path, List filenames inside and open & copy data
    By SBBmaster09 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-07-2016, 06:46 AM
  2. [SOLVED] Saving excel sheets to folder - problem with Dim sFile ect
    By k1989l in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-01-2016, 08:11 AM
  3. Reduce processing time for saving excel sheets located in a folder
    By rexer231 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-06-2014, 05:28 AM
  4. saving to a specific file path
    By cartica in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-05-2013, 04:06 PM
  5. Code to list the folder path and sub folder path of a specific file
    By kalai1587 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2013, 03:51 AM
  6. Replies: 0
    Last Post: 10-10-2012, 03:51 AM
  7. Saving workbook inside new folder
    By rhudgins in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-19-2011, 12:38 PM

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