MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Setting workbook properites

Posted by Eric Wright on March 15, 2001 4:24 PM

I have an ASP website that has the ability to export
data to excel and I was wondering if there is a way to set some of the properties of the workbook at the same time.

Thanks Eric

Posted by Dave Hawley on March 15, 2001 10:12 PM

Eric, you can access the Doucument properties like below:

Sub TryThis
With ThisWorkbook.BuiltinDocumentProperties
.Item("Title") = "My Book"
.Item("Subject") = "Maths"
End With
End Sub

To see the full list of Items, place your mouse insertion point in "BuiltinDocumentProperties" and push F1


OzGrid Business Applications