Is there a VBA command/function that will give me the workbook/worksheet name, as well as the creation and modification dates?
Is there a VBA command/function that will give me the workbook/worksheet name, as well as the creation and modification dates?
Seeproperty in the help systemPlease Login or Register to view this content.
and/or
propertyPlease Login or Register to view this content.
Last edited by barryleajo; 07-11-2011 at 03:17 PM. Reason: forgot code tags!
Please Login or Register to view this content.
EDIT: All the possible BuiltinDocumentProperties:
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)
Last edited by JBeaucaire; 07-11-2011 at 03:23 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hello LydiasDad,
This macro will return the ActiveWorkbook's name, name of the ActiveSheet, the creation date and the last modification date.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks