Have AutoDate On, Then Off

[Michale32086]

I use EXCEL 2007 to create work orders and invoices for a small computer shop..

I have a template that I work from that has a cell with an auto-date feature. This saves me time by not having to insert the date all the time.

When I fill out an invoice or work order, I save the template document as a separate document that I can later bring back up and refer to..

Unfortunately, when I open the document, the date it was created (as shown in the Auto Date cell) is changed to the current date.

What I want to do is to keep the auto-date in the template but, when I save it, have the auto-date turned off so that upon subsequent viewings, the date stays the same.

Is this possible??

I should also note that as near as I can tell, the original "template" is not a real template in the EXCEL sense of the word. IE not saved as an .xlt file, but rather just an .xls file that I call a template..

I also have access to EXCEL 2010 if that could do for me what I need.

Thanx.

Michale

 

[jasonb75]

Looks like I may have jumped the gun...

While it's true that the DateTestx.xls document had the plain date in it, so does the TEMPLATE-WORK.xlt template...

Michale

That is correct, but the code will change the date when you open it again, (see my previous post in reference to this, as you nedd to prevent it in the copies).

Where's a head banging emoticon when ya need one!

you mean this one

 

[Michale32086]

That is correct, but the code will change the date when you open it again, (see my previous post in reference to this, as you nedd to prevent it in the copies).

Ahhhh I see...

So the Auto Date "formula" is in the VBA code, not in the cell???

you mean this one

That'll work!! :D


Thanx again...

Michale....

 

[Michale32086]

Just a follow-up on this..

I opened a document and it worked beautifully... :D

So, if I understand things right, as long as I save the document as xxxxx.xlsx, then the date will be preserved, right?

A million thanx.. :D


Michale

 

[jasonb75]

That is correct, the date is updated by macro and .xlsx workbooks will not save the code.

I do have an alternative method that doesn't rely on any code if you want something that doesn't rely on you remembering the correct file extension, but not 100% certain it will work.

I'll set up a test now and see what happens to it tomorrow.

 

[Michale32086]

That's kewl.. This will work.. I do about a dozen of these a weekend, so remembering the .xlsx extension won't be a big deal..

All of the old files are in one directory so if there is a way to apply this to a dir, that would be fantastic.

Thanx again..

Michale...