SUBSCRIBE.TO macro

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

Return to index