Results 1 to 12 of 12

Macro to Save As a file with a date in dd-monthname-yyyy

Threaded View

  1. #1
    Registered User
    Join Date
    02-21-2012
    Location
    went ighboado
    MS-Off Ver
    Excel 2010
    Posts
    8

    Thumbs up Macro to Save As a file with a date in dd-monthname-yyyy

    Hi

    Can you suggest me a macro which will save a new workbook created using a macro in this particular format:

    "Filename dd-monthname(3digits only)-yyyy"

    Example: "Alarm Logs 16-Mar-2012"

    If the month name is not possible for three digits, it can be as "Alarm Logs 16-March-2012" but the capital letter for month is important.


    Any help would be appreciated.

    Thank you in advance
    Last edited by witcomm; 03-16-2012 at 02:31 AM. Reason: prefix change

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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