Can I print the File Properties?

C

Chas

Useful information can be stored in the file properties
area ( click File | Properties). Is there a way to print
the information that is stored in that area? Can it be
printed at the same time as its spreadsheet?

Thanks!
 
R

Ron de Bruin

Check out the VBA help for
BuiltinDocumentProperties

You can add the information to your sheet

Or print a screenshot of the dialog
Application.Dialogs(xlDialogProperties).Show
 
C

Chas

Thanks Ron! Neat add-ins at your site too.
-Chas
-----Original Message-----
Check out the VBA help for
BuiltinDocumentProperties

You can add the information to your sheet

Or print a screenshot of the dialog
Application.Dialogs(xlDialogProperties).Show



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)




"Chas" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
 
Top