+ Reply to Thread
Results 1 to 4 of 4

Save File as Date

  1. #1
    Registered User
    Join Date
    12-16-2009
    Location
    Toledo, OH
    MS-Off Ver
    MS Office 2007 Enterprise
    Posts
    2

    Save File as Date

    I use the same spreadsheet every day to record where I go, and what time I get there.
    I recently discovered "=now()" which inserts the current date and time into a cell. Cool, now when I open my spreadsheet, the date and time is already filled in.
    Every day, I still must click, file, save as, and enter a new file name (always today's date) when I'm done for the day. Shouldn't I be able to just close the file, and it saves as the =now() value automatically? I use Office 2007 enterprise. I can maybe explain it better?

    How do I automatically save a file with the name of a cell? The cell will have the value of =now(). I do not want to click on file, save as, then change the date everyday (which often I enter an error and can not find a day, or worse, overwrite a day).
    So each day, I want to open the same file (ie, DailyTrip.xls) and then have it auto save as =now() value, or somehow the current date. this will not work.... when i review the files for billing, and i open the file with the dated name, will it change to the current value of now? this will not work.... all files would end up with saturday's date for file name when I process billing. any ideas on how to make this work?

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,486

    Re: Save File as Date

    Try this, it will save and put the date saved at the end
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    12-16-2009
    Location
    Toledo, OH
    MS-Off Ver
    MS Office 2007 Enterprise
    Posts
    2

    Re: Save File as Date

    That might work... Where can I go to learn what any of that means? I tried pulling out the excel 98 book I have, but I couldn't find anything about inserting/installing/using code. I think the book I have is too basic. I am struggling with the F1 help. Possibly a link to a start?
    Thanks

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,486

    Re: Save File as Date

    Check this out to insert code into a regular module
    http://www.contextures.com/xlvba01.html#Regular

+ 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