Can I print the File Properties?

  • Thread starter Thread starter Chas
  • Start date Start date
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!
 
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
 
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
message news:[email protected]...
 
Back
Top