Using OpenOffice Calc

[Jhony]

Look the code:

#Include <OOoCOM_UDF.au3>

local $fn = @ScriptDir & "\test.xls"

$oCurCom = _OOoCalc_Open($fn)

$value = _OOoCalc_ReadCell ($oCurCom, 0, 0, 0)

MsgBox(1, "AutoIt", $value)

Exit

I want to show the $value but i can't show the test.xls, an my code show the test.xls, how i can hide the test.xls and show $value??

Please i need do this.

Thanks.

[AutoBert]

Hello Jhony,

i can't find your included File: OOoCOM_UDF.au3. Please attach the link to your first post,

thank's autoBert

[Jhony]

Hello Jhony,

i can't find your included File: OOoCOM_UDF.au3. Please attach the link to your first post,

thank's autoBert

Link:

thanks for help

[AutoBert]

There isn't your included File, without i can't help you

bye atoBert

[Jhony]

There isn't your included File, without i can't help you

bye atoBert

tomorrow i inclue my fle, if u can help

thanks

[AutoBert]

Hey Jhony,

i can try it, but witout nobody can try it

Edit: I found a UDF in but this one seems to be bgy or don't work with OpenOffice 2.2 Portable

mfg autoBert

Edited March 1, 2011 by AutoBert

[Jhony]

My files

01_CalcOpenFile.au3

teste.rar

[joeloyzaga]

Jhony - I tried your example and get this error - being a newbie I haven't the slightest idea where to start

C:\Program Files (x86)\AutoIt3\Include\OOoCOM_UDF.au3 (339) : ==> Variable must be of type "Object".:

$oPropertyValue = $oSM.Bridge_GetStruct("com.sun.star.beans.PropertyValue")

$oPropertyValue = $oSM^ ERROR

[BrewManNH]

Jhony hasn't been active here since March of last year, I wouldn't expect him to answer.