+ Reply to Thread
Results 1 to 3 of 3

save files in specific folders

  1. #1
    Registered User
    Join Date
    08-21-2015
    Location
    Ho Chi Minh
    MS-Off Ver
    Vietnam
    Posts
    40

    save files in specific folders

    I have a vba code that can split a Total file into many small files. Then it can save these files into a same folder with the Total file

    However, I want to save these files into many specific folders that have the same four letter with the Agency

    Moreover, can I add creation day in the name of the small files. For example "A001 160916"

    Thanks all
    Attached Files Attached Files
    Last edited by dtaphuong; 09-16-2016 at 12:14 PM.

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2211 (Build 15813.20002) Win 11 Home 64 Bit
    Posts
    22,098

    Re: save files in specific folders

    Post your VBA code so that we can review, analyze and hopefully amend to give you what you desire.
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    08-21-2015
    Location
    Ho Chi Minh
    MS-Off Ver
    Vietnam
    Posts
    40
    Quote Originally Posted by alansidman View Post
    Post your VBA code so that we can review, analyze and hopefully amend to give you what you desire.
    Yes, I just post my file that have Vba code

+ 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. Macro to open, update links, save then close all files in sub folders
    By msdelaney in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-03-2015, 05:48 PM
  2. Create folders and save text files to these folders
    By bloomingcarrot in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-03-2014, 08:14 PM
  3. Replies: 2
    Last Post: 08-18-2014, 08:39 PM
  4. Rule to save attachments to specific folders depending on attachment file name
    By ndrobinson in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 09-17-2013, 04:16 PM
  5. Copy specific data from different range of files saved in different folders
    By phoenixwright in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2013, 07:47 PM
  6. Replies: 0
    Last Post: 12-04-2012, 01:01 PM
  7. How to Move specific files to folders with VBA
    By EnzioL in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-09-2012, 06:46 AM

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