Hi Unifacers
with U9/U10 we succesfully read and write Microsoft Excel cells using the (very old) DDE method; so basically we open a Microsoft Excel file, and while open in the background doing the following:
$50 = "Excel"
$51 = "c:\temp\filename.xls"
$52 = "R1C1"
perform "UDDEREQUEST"
and we get succesfully in $53 the value of the cell
is there a way to do the same with LibreOffice Calc instead of Microsoft Excel? I googled something and just found that I should replace my instructions like this:
$50 = "soffice"
$51 = "c:\temp\filename.xls" (or filename.ods)
$52 = "nameofthesheet.C1"
but it does not work.. anyone tryed to do something similar? or you left alone DDE and went to other methods like OLE or others?
a working example would be great
thank you
Simone
------------------------------
Simone Pecchenino
Labinf Sistemi Srl
IT
------------------------------