Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

click "Next" link in libreCalc macro

When I click "Next" link in libre-macro coding, it will return an error as "BASIC runtime error.'1'

Type: Message: [automation bridge] The object does not have a functionor readable property "Click""

Option VBASupport 1

Sub nextlink()
URL = ""

Set ie = CreateObject("InternetExplorer.Application")
ie.Visible = True
ie.Navigate URL

Do While ie.ReadyState <> 4

oSheet = ThisComponent.getSheets().getByIndex(0)

doc = ie.document.body
Dim nextlink As Object
Set nextlink=doc.getElementsByClassName("pagenav")
For Each nlink In nextlink
 if(nlink.innerText="Next") Then
 End If
 Next nlink

Set ie = Nothing
End Sub