SSGET(spreadsheet, reference)

The SSGET function returns the contents of a cell (or cells) from a spreadsheet. SSGET can be used from within Write documents, Spreadsheet files and Database forms.

spreadsheet is the name of a spreadsheet and must include the full path if not in the same directory as the open document. The spreadsheet extension (.aws) is not required.

reference can be a cell, range or named cell or range.

Both parameters need to be surrounded by quotes if supplied as direct references into the function.

For example:

=SSGET("sales", "A1")

returns the contents of cell A1 in a spreadsheet called sales, which must reside in the current directory.

=SSGET(B1, B2)

would return the same if cells B1 and B2 simply contain the text sales and A1 respectively.

=SUM(SSGET("sales", "C1..C10"))

returns the sum of cells C1 through C10. If C1 through C10 were named as a range called totalsales, then the following function would be identical to the above:

=SUM(SSGET("sales", "totalsales"))

To return a cell from a spreadsheet in a specific directory, use the full path as follows:

=SSGET("C:\My Documents\sales", "A1")

See also:

Linking to Database

Linking to Write

Other remote functions