i only know how to do this thorough VBA, but assuming X represents the
Text object you wish to put the information into it would be something
like this
X.text = excel.Workbooks("Name of workbook").Worksheets("Name of
worksheet").range("cell address")