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
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