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