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: