Get Cell Values/Comments from Another Workbook(Offline)

[Ozgur Emre]

Hello
I have a workbook and it's address is C:\Yetki.ods ; I need some cell comments from this workbook; and I will put these comments to another workbook's cells.
Is there any way to get some cell values/Comments from another workbook without open it?
For example I want to get cell(1,1)'s comment.
I couldn't refer the other book, I don't know how to.

We have formulas but that doesn't bring cell comments.(annotations)
Thank you anyway.

[Villeroy]

[Tutorial] External Links In Calc. Spreadsheets operate on cell values only. All the other elements are illustration and decoration.

[einstein]

And After using external links then (maybe) we can use a user-defined function.
This function returns the comment of equis cell.
=COMENTARIO("SheetName";"D4")

Code: Select all

Function Comentario(Hoja, celda)
	   oDoc = ThisComponent
	  hojas = oDoc.getSheets()
	 oSheet = hojas.GetByName(hoja)
	  oCell = oSheet.getCellRangeByName(celda)
      oCmt = oCell.getAnnotation()
   oCmtStr = oCmt.getString()
 Comentario = oCmtStr
End Function