DocumentProperties Property

[VBScript]
Property DocumentProperties SADocumentProperties (read-only) 

Returns a DocumentProperties object which represents properties of the specified spreadsheet. In Microsoft Excel, these properties are displayed in the Properties sheet. To view the Properties sheet, open Excel's File menu, and select Properties.

[VBScript]

Dim XlwApp, DocProps, App, CreateDate

'--- Create an instance of ExcelWriter 
Set XlwApp = Server.CreateObject("SoftArtisans.ExcelWriter")

'--- Get a reference to SADocumentProperties
Set DocProps = XlwApp.DocumentProperties

'--- Use DocumentProperties properties
App = DocProps.Application ' returns "SoftArtisans ExcelWriter"
DocProps.Author = "Ms. Jane Doe"
DocProps.Category = "Marketing Category"
DocProps.Comments = "This document contains internal company data."
DocProps.Company = "Product Company, Inc."
CreateDate = DocProps.CreationDate
DocProps.Keywords = "Marketing,Products,Report,Internal"
DocProps.LastSavedBy = "J. Doe"
DocProps.LastSavedDate = "2/24/2004"
DocProps.LinksUpToDate = True
DocProps.Manager = "John Someone"
DocProps.RevisionNumber = "1.1.2"
DocProps.ScaleCrop = False
DocProps.Subject = "Quarterly Marketing Data"
DocProps.Title = "Marketing Report 1Q 2004"

'--- Use the Clear method to clear document properties
DocProps.Clear