+ Reply to Thread
Results 1 to 3 of 3

Adding current date to a file in vba

  1. #1
    Registered User
    Join Date
    07-04-2012
    Location
    New Zealand
    MS-Off Ver
    Excel 2007
    Posts
    1

    Adding current date to a file in vba

    Hi all

    I have a code I want to alter so it creates a new folder with the current month and then creates a file with the current date.
    Here is my code snippet:

    Please Login or Register  to view this content.
    Thanks
    Sunny
    Last edited by Cutter; 07-04-2012 at 07:38 PM. Reason: Code tags added

  2. #2
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Adding current date to a file in vba

    Hello Sunny1808, and welcome to the forum.

    I have placed code tags around your code. Please keep in mind that the forum rules require you to add them whenever posting code.

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

  3. #3
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Adding current date to a file in vba

    Hi Sunny,

    There's probably a better way but try this:

    Please Login or Register  to view this content.
    Last edited by xladept; 07-04-2012 at 09:15 PM.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

+ Reply to Thread

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