Excel 2007 - version

[lauriebizz]

Is there a way to auto create a version # in a workbook. Then insert to display in a cell?
Thanks-
Laurie

 

[lauriebizz]

I should clarify - the document version, not the version of excel.
Thanks-
Laurie

 

[SkipVought]

hi,

These are the document attributes for a workbook
[tt]
Title
Subject

Author

Keywords

Comments

Template

Last Author

Revision Number

Application Name

Last Print Date
Creation Date
Last Save Time

Total Editing Time

Number of Pages

Number of Words

Number of Characters

Security

Category

Format

Manager
Company
Number of Bytes

Number of Lines

Number of Paragraphs

Number of Slides

Number of Notes

Number of Hidden Slides

Number of Multimedia Clips

Hyperlink Base

Number of Characters (with spaces)
[/tt]

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[lauriebizz]

Great, so how do I show an attribute in a cell? I know I'm over-thinking it...
Thanks-
Laurie

 

[lauriebizz]

Ah, I found a thread that answers my question.
Thanks!!
Laurie

 

[SkipVought]

Please post your solution, for the benefit of other members.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[lauriebizz]

I found the solution here:

http://www.tek-tips.com/viewthread.cfm?qid=405157&page=1

Though admittedly, I haven't tried it yet.

Thanks-
Laurie