Hello.
I have a long and boring task ahead: I have to type about a thousand rows of data that I already have in a Calc sheet into an HTML Form, so I am trying to write a macro to do it with a method like “oIE.getObjByName” or something similar.
I have search several hours how to get to IE DOM objects from LibreOffice but had no luck at all. The code I have by now:
oOLE = createUnoService(“com.sun.star.bridge.OleObjectFactory”)
oIE = oOLE.createInstance(“InternetExplorer.Application.1”)
If Not IsNull(oExplorer) Then
oIE.visible = true
oIE.Navigate(“https://www.myurl.com”)
So far ok, but as I try to check:
oIE.ReadyState
or
oIE.Document
I get the error:
Type: com.sun.star.uno.RuntimeException
Message: [automation bridge] Could not get FUNCDESC for ReadyState.
Could any one help me to get to the HTML elements?
Thanks in advance!