+ Reply to Thread
Results 1 to 3 of 3

macro to save file in current month

  1. #1
    Registered User
    Join Date
    08-24-2012
    Location
    Maharashtra, Pune
    MS-Off Ver
    Excel 2007
    Posts
    56

    Question macro to save file in current month

    Hi Friends,

    I want a micro to save file with name and current date
    example
    Report16.03.13

    but it should be saved in a folder C:\Reports
    and it should save it in Months folder if current month folder is not present it should create it and save file daily on current month folder, please help

    Thanks in advance

  2. #2
    Valued Forum Contributor xlbiznes's Avatar
    Join Date
    02-22-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2007
    Posts
    1,223

    Re: macro to save file in current month

    Hi,

    try this code. Hope this helps.

    Please Login or Register  to view this content.
    Happy Computing ,

    Xlbiznes.

    To show your appreciation please click *

  3. #3
    Registered User
    Join Date
    08-24-2012
    Location
    Maharashtra, Pune
    MS-Off Ver
    Excel 2007
    Posts
    56

    Re: macro to save file in current month

    thank you great work,

    but it is creating folder for each day, I want it to create folder for new month only if not present.

    if present it should save file in current month folder

    In short I want to save file daily in month folder so for next month i will have to create new month folder so i want a macro which will save file in current months folder if current month folder is not present it should create and save files in that folder.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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