+ Reply to Thread
Results 1 to 7 of 7

Copy workbook for every day of the year - 365 days

  1. #1
    Registered User
    Join Date
    01-25-2022
    Location
    New Orleans
    MS-Off Ver
    2013
    Posts
    5

    Copy workbook for every day of the year - 365 days

    Hello, I'm not sure this is a basic question... I have to copy a workbook for each day of the year 365 times. The date also has to be in the first cell of the workbook. I have done it manually for the month of January. Is there a way to automate this?

    I attached two workbooks to just show the date changes and maybe give an idea of what I'm trying to do without manually having to do this for every day of the year.

    thanks for your help.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,198

    Re: Copy workbook for every day of the year - 365 days

    Welcome to the forum.

    Thread moved to the VBA section, as this will require coding.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Valued Forum Contributor
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    365 32bit Win
    Posts
    438

    Re: Copy workbook for every day of the year - 365 days

    How about this?


    Place in standard module of one of the workbooks, change saveas path and run.
    You'll be left with the last workbook open.
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    01-25-2022
    Location
    New Orleans
    MS-Off Ver
    2013
    Posts
    5

    Re: Copy workbook for every day of the year - 365 days

    Thank you.

  5. #5
    Registered User
    Join Date
    01-25-2022
    Location
    New Orleans
    MS-Off Ver
    2013
    Posts
    5

    Re: Copy workbook for every day of the year - 365 days

    thank you! Can you help me with changing the path?

  6. #6
    Valued Forum Contributor
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    365 32bit Win
    Posts
    438

    Re: Copy workbook for every day of the year - 365 days

    Hi,
    Just change the red part to the path of the folder where you're saving them.

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    01-25-2022
    Location
    New Orleans
    MS-Off Ver
    2013
    Posts
    5

    Re: Copy workbook for every day of the year - 365 days

    Thank you so much! Worked perfectly

+ 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. Replies: 2
    Last Post: 01-22-2019, 03:15 AM
  2. [SOLVED] Formula to calculate working days and calendar days per month-year ?
    By donny007 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-05-2018, 06:23 PM
  3. Replies: 16
    Last Post: 08-22-2017, 11:20 AM
  4. [SOLVED] calculate total number of days between two days based on 365 days year
    By aparunkumar in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-14-2016, 12:51 AM
  5. Replies: 2
    Last Post: 01-06-2013, 04:27 PM
  6. [SOLVED] Count days for specific year falling within in multi-year date range
    By jslo2013 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-04-2012, 05:58 PM
  7. Convert a multiple year list of 365 days/year into an equivalent of 360 days/year
    By lobotomy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-24-2012, 05:39 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