Workbooks("q.xls").author = ""

[michelle]

Dear vb users,

I am trying to reset the author of an Excel sheet with the next command:

Workbooks("q.xls").author = "New"


The only choice I do have is:

- Workbooks("q.xls").AutoUpdateFrequency
- Workbooks("q.xls").AutoUpdateSaveChanges

How can I make the choice for .Author?

My references are connected with: Microsoft Excel8.0 Object Library

Nice regards,

Michelle.

[netSurfer]

Are you doig this in VB or excel's VBA macros? I'm not sure if you can do it via VB. An interesting thing I found access Word and Excell via Access was that there is an pobject browser that lets you see properties etc. Doing this really helped alot figuring out the property name etc that I needed to edit. Hope this helps a little. I'm in the middle of something but when I get a chance I'll try to figure the exact syntax. Are you sure that you are able to edit the Author of an Excel sheet?