|
|
ExcelApplication Object Reference
DocumentProperties Property
Syntax:
[VBScript] Property DocumentProperties SADocumentProperties (read-only)
Description:
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.
Example:
[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
Copyright © 2005, SoftArtisans, Inc.