change the company name

[Crystal]

Can anyone here tell me how to automatically change the
default company name in new Word/Excel/PowerPoint2002
document (i.e. the one that is created when
Word/Excel/PowerPoint2002 is initiated) without
reinstalling OfficeXP? Thanks. Dina

 

[Tushar Mehta]

Can anyone here tell me how to automatically change the
default company name in new Word/Excel/PowerPoint2002
document (i.e. the one that is created when
Word/Excel/PowerPoint2002 is initiated) without
reinstalling OfficeXP? Thanks. Dina

I guess by writing a macro that monitors the creation of new documents
and executing the appropriate variation of

ActiveWorkbook.BuiltinDocumentProperties("company").Value = _
"dina crystal's company"
MsgBox ActiveWorkbook.BuiltinDocumentProperties("company").Value


--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions