SUBSCRIBE.TO

Macro Sheets Only

Inserts the contents of the edition into the active sheet at the point of the current selection. Use SUBSCRIBE.TO to incorporate editions published from other workbooks into your Microsoft Excel worksheets and macro sheets. SUBSCRIBE.TO returns TRUE if successful.

Syntax

SUBSCRIBE.TO(file_text, format_num)

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

File_text is the name, as a text string, of the edition you want to insert into the active sheet. Unless file_text is in the current folder, supply the full path of the workbook. If file_text cannot be found, SUBSCRIBE.TO returns the #VALUE! error value and interrupts the macro.

Remarks

Format_num is the number 1 or 2 and specifies the format type of the file you are subscribing to.

Format_num Format type

1 or omitted Picture

2 Text (includes BIFF, VALU, TEXT, and CSV formats)

Related Functions

CREATE.PUBLISHER Creates a publisher from the selection

EDITION.OPTIONS Sets publisher and subscriber options

GET.LINK.INFO Returns information about a link

List of Command-Equivalent Functions