Web Options Properties

Name

Returns

Description

AllowPNG

Boolean

Set/Get whether Portable Network Graphics Format (PNG) is allowed as an output format. PNG is a file format for the lossless, portable, well-compressed storage of images

DownloadComponents

Boolean

Set/Get whether Office components are downloaded to the end user's machine when viewing Excel files in a web browser

Encoding

MsoEncoding

Set/Get the type of code page or character set to save with a document

FolderSuffix

String

Read-only. Returns the suffix name for the support directory created when saving an Excel document as a web page. Language dependent

LocationOf Components

String

Set/Get the URL or path that contains the Office Web components needed to view documents in a web browser

OrganizeIn Folder

Boolean

Set/Get whether supporting files are organized in a separate folder from the document

PixelsPerInch

Long

Set/Get how dense graphics and table cells should be when viewed on a web page

RelyOnCSS

Boolean

Set/Get whether Cascading Style Sheets (CSS) is used for font formatting

RelyOnVML

Boolean

Set/Get whether image files are not created when saving a document with drawn objects. Vector Markup Language is used to create the images on the fly. VML is an XML-based format for high-quality vector graphics on the web

Name

Returns

Description

ScreenSize

MsoScreen Size

Set/Get the target monitor's screen size

Target Browser

MsoTarget Browser

Set/Get the browser version

UseLongFile Names

Boolean

Set/Get whether links are updated every time the document is saved

WebOptions Methods

Name

Description

UseDefault FolderSuffix

Tells Excel to use its default naming scheme for creating supporting folders

WebOptions Object Example

Sub SetWebOptions()

Dim oWO As WebOptions

Set oWO = ActiveWorkbook.WebOptions

With oWO

.ScreenSize = msoScreenSize800x600 .RelyOnCSS = True .UseDefaultFolderSuffix End With End Sub

Sub SetWebOptions()

Dim oWO As WebOptions

Set oWO = ActiveWorkbook.WebOptions

With oWO

.ScreenSize = msoScreenSize800x600 .RelyOnCSS = True .UseDefaultFolderSuffix End With End Sub

0 0

Post a comment