+ Reply to Thread
Results 1 to 6 of 6

save files to specific folders and creates folders based on month

  1. #1
    Forum Contributor
    Join Date
    02-08-2021
    Location
    africa
    MS-Off Ver
    2016
    Posts
    387

    save files to specific folders and creates folders based on month

    hello
    I would create folders based on year so current year should 2021 and folder 2021 should creates many folders based on month of years JAN, FEB ... etc. and when i save the files as pdf based on dated on h2 in this case should save to folder 2021 and subfolder 'MAR'
    and when finish years 2021 then create a new year 2022 and so on
    Attached Files Attached Files
    Last edited by MKLAQ; 03-21-2021 at 09:03 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    09-30-2018
    Location
    Vlaams Brabant Belgium
    MS-Off Ver
    365
    Posts
    456

    Re: save files to specific folders and creates folders based on month

    Give this a try

    Please Login or Register  to view this content.
    Please be as complete as possible in your asking so it may save use all the time to rework the solution because you didn't give all the requirements. If you have a layout in mind please work it out first so we can adapt our solution to it. Thanks.
    If you have been helped, maybe you could click the *

  3. #3
    Forum Contributor
    Join Date
    02-08-2021
    Location
    africa
    MS-Off Ver
    2016
    Posts
    387

    Re: save files to specific folders and creates folders based on month

    Wow it's very impressive i tested every month it create the folder and subfolder but the question is if I finish this year and get in a new year 2022 then will create a folder 2022 or not ?

  4. #4
    Valued Forum Contributor
    Join Date
    09-30-2018
    Location
    Vlaams Brabant Belgium
    MS-Off Ver
    365
    Posts
    456

    Re: save files to specific folders and creates folders based on month

    try it

    type 10/02/2022 in H2

    it should work just fine

  5. #5
    Forum Contributor
    Join Date
    02-08-2021
    Location
    africa
    MS-Off Ver
    2016
    Posts
    387

    Re: save files to specific folders and creates folders based on month

    yes it works many thanks buddy
    well done !

  6. #6
    Forum Contributor
    Join Date
    02-08-2021
    Location
    africa
    MS-Off Ver
    2016
    Posts
    387

    Re: save files to specific folders and creates folders based on month

    Hi
    just I'm asking about how get rid if the empty rows after save as pdf I 'm talking about ranges b20:h34 if they contain empty then should ignore the empty rows
    thanks again

+ 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. [SOLVED] Save pdf to specifc year/month folder + manage folders based on CDate
    By vendam in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-09-2020, 12:29 AM
  2. Replies: 5
    Last Post: 11-02-2018, 03:15 AM
  3. save files in specific folders
    By dtaphuong in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-16-2016, 12:17 PM
  4. 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
  5. Replies: 1
    Last Post: 09-12-2013, 09:23 PM
  6. Excel macro that creates pdf files in Dropbox folders works inconsistently in Windows 8
    By KathyS_893 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-23-2013, 12:03 AM
  7. Replies: 0
    Last Post: 12-04-2012, 01:01 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