+ Reply to Thread
Results 1 to 1 of 1

Macro to 'save as' a template in the next month folder

  1. #1
    Registered User
    Join Date
    Alberta, Canada
    MS-Off Ver

    Macro to 'save as' a template in the next month folder

    Hi, I have the following macro I use to save a workbook (Help from another forum member who kindly helped me solve it) with the next chronological date.
    I have added some code to it in order to open the template, and then save it to the proper folder.
    I would like to know where I go or what code to add in order to save the folder in the next month folder.
    Ie, in my code it is currently pathed to save it in the folder July.
    What I would like to do is add code to the macro to have the macro save it automatically to the next month (August) when it is July, 31 2014
    The folder would simply be called August. And on August 31 the next folder would be September and so on.
    I don't know if that would require a pop-up prompt asking for the month. My goal is to have one macro that will
    1) Open the template from the template folder
    2) Save the template as the next chronological date as in the current code
    3) save automatically to the next month folder when the next day will be the next month.
    4) Or prompt for next month folder name.
    Here is my code:

    Please Login or Register  to view this content.
    Any help is appreciated.
    kind regards
    Last edited by shikano53; 07-07-2014 at 06:20 PM.

+ 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: 4
    Last Post: 06-26-2014, 03:13 PM
  2. How to save file in respective month folder as per current year vba modification
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-03-2014, 05:26 PM
  3. Setting a default save folder for a template
    By postitnote100 in forum Excel General
    Replies: 2
    Last Post: 10-17-2013, 05:23 PM
  4. [SOLVED] Save invoice to folder by month and then save file by date and invoice
    By Val777 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-03-2013, 02:57 AM
  5. [SOLVED] Macro to Save a PDF in folder by month
    By tomisthereason in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-25-2013, 05:06 AM


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