Auto Properties in Office 2007 HELP!!

K

Kevin Clark

I use Office 2007 - Very nice - But for example i use Excel for Purchase
orders and save every one after 'Prepare' - 'Properties' And filling in the
client in 'Auther' then the payment method in 'Title' then the vendor in
'Subject' and the amount in 'Comment'.
So now when i look at the folder containing the hundreds of purchase orders
i can see all this info and more importantly click on the column headings to
sort the data for me to search through it.
QUESTIONS.
Is it possible to have these properties find this data in the Excel sheet
and save me the time?

Am i doing it all wrong? as in do others with lots of word/Excel files in
one folder have a better method for organizing them?

Any replies greatly appreciated.

Kev
 
K

Kevin Clark

Hmmm, i have no idea what access is. I will look into it. More damn learning.
Does it ever end?

Thanks DL
 
B

Beth Melton

In Word 2007 there are Bound Property fields which means you can insert them
and update them from the document. But for Excel you need to access the
built-in properties using VBA. If they are built-in properties then you can
display them using code such as:

Cells(1, 1).Value = ActiveWorkbook.BuiltinDocumentProperties("Title")

And update them using code such as:

ActiveWorkbook.BuiltinDocumentProperties("Title") = Cells(1, 1)

However unlike Word you'd need to create macros for both the display and
update.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
 
Top