How to change in Excel the Author (Properties) with VBA ? 1

[gtaborda]

Hi there

I have a VBA macro which creates a new excel document (from a "Master Excel doc) and saves it to a set directory.

Several people can do this process and I would like to change the "Author" on the properties of the newly created document, just before it is saved, in order to keep a control of who did it.

Could anyone advise how this could be done ?

Your help is appreciated

thanks

 

[combo]

Having reference to the workbook:
WorkbookRef.BuiltinDocumentProperties("Author") = Environ("USERNAME")

combo

 

[Chance1234]

This any help

http://www.vbaexpress.com/kb/getarticle.php?kb_id=730

Chance,

F, G and Skipper

 

[gtaborda]

Hi, thanks for answering

Yes !!!!! using

WorkbookRef.BuiltinDocumentProperties("Author") = Environ("USERNAME")

works !!!!!

I had to do a small change, usng Activeworkbook. instead of workbookref. and it works perfectly

ActiveWorkbook.BuiltinDocumentProperties("Author") = Environ("USERNAME")

Thanks Combo !

thank you both for your suggestions