CREATE.PUBLISHER

Macro Sheets Only

Equivalent to choosing the Create Publisher command from the Publishing submenu on the Edit menu. Publishes the selected range or chart to an edition file for use by other Macintosh applications.

Important This function is only available if you are using Microsoft Excel for the Macintosh with system software version 7.0 or later.

Syntax

CREATE.PUBLISHER(file_text, appearance, size, formats)
CREATE.PUBLISHER?(file_text, appearance, size, formats)

File_text is a text string to be used as the name of the new file that will contain the selected data. If file_text is omitted, Microsoft Excel uses the format "<WorkbookName> Edition #n", where WorkbookName is the name of the document from which the publisher is being created, Edition indicates that the file is an edition file, and n is a unique integer.

For example, if you omit file_text and are publishing a selection from a workbook named Seasonal, and it is your third publisher from that document in the current work session, the default name of the publisher would be "Seasonal Edition #3".

Appearance specifies whether the selection is to be published as shown on screen or as shown when printed. The default value for appearance is 1 if the selection is a sheet and 2 if the selection is a chart.

Appearance Selection is published

1 As shown on screen

2 As shown when printed

Size specifies the size at which to publish a chart. Size is only available if a chart is to be published.

Size Chart is published

1 or omitted As shown on screen

2 As shown when printed

Formats is number specifying what file format or formats CREATE.PUBLISHER should use when it creates the Edition file.

Formats File format

1 PICT

2 BIFF

4 RTF

8 VALU

• You can also use the sum of the allowable file formats for formats. For example, a value of 6 specifies BIFF and RTF.
• If formats is omitted and the document is a sheet, formats is assumed to be 15 (all formats); if the document is a chart, formats is assumed to be 1 (PICT).

Related Functions

EDITION.OPTIONS Sets publisher and subscriber options

GET.LINK.INFO Returns information about a link

SUBSCRIBE.TO Inserts contents of an edition into the active workbook

UPDATE.LINK Updates a link to another workbook

List of Command-Equivalent Functions