#1   Report Post  
Old July 22nd 08, 04:32 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2008
Posts: 112
Default Dating a file.

What can I add to a file, that I send out periodically, to date stamp that
version of the file?
--
Matt S

  #2   Report Post  
Old July 22nd 08, 04:40 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
Posts: 1,358
Default Dating a file.

Well, you could just put the date in the filename itself....such as..

Myfile 07 22 08.xls
--
John C


"Matt S" wrote:

What can I add to a file, that I send out periodically, to date stamp that
version of the file?
--
Matt S

  #3   Report Post  
Old July 22nd 08, 04:52 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2008
Posts: 112
Default Dating a file.

OK That would work but I was looking for a seemless approach. I mean I don't
want to have to add todays date to the file manually.

Can I use the Today() function and some how cause it to be locked so that
when someone looks at the file at a later date it won't show that date?
--
Matt S


"John C" wrote:

Well, you could just put the date in the filename itself....such as..

Myfile 07 22 08.xls
--
John C


"Matt S" wrote:

What can I add to a file, that I send out periodically, to date stamp that
version of the file?
--
Matt S

  #4   Report Post  
Old July 22nd 08, 05:05 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
Posts: 1,358
Default Dating a file.

Well, if it were to 'somehow' be locked, i.e.: upon saving, you may
inadvertantly lock it as well. There will be something that you will need to
do to the file, either typing in the date in a cell, or using a naming
convention for the file name for a copy of the file, in any case. The
advantage of the naming convention that I have suggested, is that if you also
keep a history of all the 'old' files, then if there is ever any question,
you do not have to recreate any of the older versions, just open the one with
the approrpriate date.

Just my 2 cents.
--
John C


"Matt S" wrote:

OK That would work but I was looking for a seemless approach. I mean I don't
want to have to add todays date to the file manually.

Can I use the Today() function and some how cause it to be locked so that
when someone looks at the file at a later date it won't show that date?
--
Matt S


"John C" wrote:

Well, you could just put the date in the filename itself....such as..

Myfile 07 22 08.xls
--
John C


"Matt S" wrote:

What can I add to a file, that I send out periodically, to date stamp that
version of the file?
--
Matt S

  #5   Report Post  
Old July 22nd 08, 06:57 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,907
Default Dating a file.

You just hit CTRL + ;(semi-colon) to enter a fixed date in a cell.

There are several other methods using VBA to place the last saved date in a
cell or header/footer or a msgbox that pops up when user opens the file.


Gord Dibben MS Excel MVP


On Tue, 22 Jul 2008 08:32:00 -0700, Matt S
wrote:

What can I add to a file, that I send out periodically, to date stamp that
version of the file?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change from american dating to uk dating? Ile Esturo Excel Worksheet Functions 1 November 28th 06 05:45 PM
How to update dating? Craig New Users to Excel 1 October 28th 06 08:09 PM
auto dating after entering the first date Jomo Watts Excel Worksheet Functions 2 April 5th 05 03:05 PM
dating problems! Jose Mourinho Excel Worksheet Functions 4 January 12th 05 06:03 PM
Progressive Dating of Columns Shadyhosta New Users to Excel 4 December 29th 04 06:06 AM


All times are GMT +1. The time now is 07:48 PM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017