How to bring information about document properties to the sheet
Posted by Tomas Krumphanzl on August 07, 2001 1:01 AM
Could you somebody tell me, how to bring information about document properties to the sheet (name of the document, author, directory, etc.). I know where to find it (File/Properties). In MS Word it is possible to use the function Inset field (Insert/field
). But there is no such a function in MS Excel. I know this problem can be solved by using a macro instruction, but the document I am working on must be macroless (without any macros). Is there any way, how to do it?
Thank you very much.
Tomas
Posted by Ivan F Moala on August 07, 2001 2:10 AM
You'll have to use xlm functions to do this,
how ever you will be limited in what info you can
get;
1)Name of the Document
2)Path of the directory of folder containing the document.
3)current user name with write permission for the document.
4)Workbook name
5)No pages to print
6)User name
7)Organisation
To get these in a cell then;
Insert | Name | Define
Type in NameDoc [to get 1 above]
then in Refers to type in;
=GET.DOCUMENT(68)
Then click on Add
Now in a worksheet cell type in as a normal formula
=NameDoc
Do the same steps as above but change the names
to a meaninful discription and define the Named
ranges as follows;
CurUser =GET.DOCUMENT(36)
Docname =GET.DOCUMENT(68)
DocPath =GET.DOCUMENT(2)
Name_of_the_Document =GET.DOCUMENT(1)
Organisation =GET.WORKSPACE(27)
Pages =GET.DOCUMENT(50)
Username =GET.WORKSPACE(26)
HTH
Ivan
