LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kjell Forssen
 
Posts: n/a
Default Changing date from =NOW() to Creation Date

Hi again!
I have been checking for the source of the date and it is not from the
workbook Own.xls(equals to personal.xls in the english version). It must be
generated of the template (*.xlt) since the date is the same whenever the
document was named and saved. In the Properties wiew under Archive there is
no date set to the Creat date on the template - it just says (unknown).
Regards
Kjell

"Kjell Forssen" skrev:

I have wrongly used the "NOW"- term to set the date in my documents which
means that every time I open and save the document the date is changed. (The
problem is solved regarding all documents created from now and onwards). Any
suggestions how to make a "global" macro or function which can pick up the
Creation Date and replace the "NOW"-term with the creation date in all those
documents that has been datechanged cause I have opened them after the
creation date?
Thanks on forehand
Kjell



 
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
Auto Date 4 changing fields in a line nastech Excel Discussion (Misc queries) 3 October 12th 05 11:49 PM
Ouput File Creation Date Sloth Excel Discussion (Misc queries) 1 October 10th 05 06:05 PM
search for latest date Sue Excel Worksheet Functions 2 August 2nd 05 11:09 PM
Changing date serial numbers rdunne Excel Discussion (Misc queries) 1 April 14th 05 12:57 PM
Auto date changing in Excel is maddening brhicks Charts and Charting in Excel 3 December 16th 04 02:54 PM


All times are GMT +1. The time now is 09:51 PM.

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

About Us

"It's about Microsoft Excel"