CreatePublisher Method

Applies To

Chart object, Range object.

Description

Creates a publisher based on a Chart or a Range object. Available only on the Macintosh with System 7 or later.

Syntax

expression.CreatePublisher(Edition, Appearance, Size, ContainsPICT, ContainsBIFF, ContainsRTF, ContainsVALU)

expression Required. An expression that returns a Chart or Range object.

Edition Optional Variant. The file name of the edition to be created. If this argument is omitted, "<Document Name> Edition #n" is used.

Appearance Optional Variant. One of xlPrinter or xlScreen.

Size Optional Variant (used only with Chart objects). One of xlPrinter or xlScreen.

ContainsPICT Optional Variant. True to include PICT format in the publisher. The default value is True.

ContainsBIFF Optional Variant. True to include BIFF format in the publisher. The default value for Range is True; the default value for Chart is False.

ContainsRTF Optional Variant. True to include RTF format in the publisher. The default value for Range is True; the default value for Chart is False.

ContainsVALU Optional Variant. True to include VALU format in the publisher. The default value for Range is True; the default value for Chart is False.

Example

This example creates a publisher based on cells A1:A20 on Sheet1.

Worksheets("Sheet1").Range("A1:A20").CreatePublisher "stock data"