Workbook Properties

  • Thread starter Thread starter incjourn
  • Start date Start date
I

incjourn

How can I read and write from the workbook properties (author, subject
title, manager etc) using VBA?

I tried recording a macro and it ended up empty?

Phi
 
Hi
for reading these properties use
msgbox ActiveWorkbook.BuiltinDocumentProperties _
(prop)

for 'prop' insert for exampl 'author', 'last save time'
etc.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro that will insert a simple text string in top cell of text file 1
Custom Document Properties in Word documents and Excel workbooks 13
VBA to VB6 6
Open Workbook Macro - with a twist 1
Don't want to hard-code file name in macro 3
Changing File "Summary" Properties Programmatically 15
Run code from another workbook 7
Workbooks within workbooks 3

Back
Top