Qlikview Macro - Is it possible to Web automate with Selenium?

paul4001 — Tue, 30 Nov 2021 18:17:33 GMT

Hi, I've got a Qlikview dashboard that has an embedded VB macro that automates web pages. Basically, using a straight table in the dashboard, the macro invokes a URL, locates items on a page and interacts with the page (posts comments, clicks buttons etc.)

The automation uses IE as the browser, due to the standard COM interface being used from the VB script.

Set IExpl = CreateObject("InternetExplorer.Application")

The problem is that automating IE in this way isn't 100% reliable. Even using delays in the script to allow the webpage to 'fully form' doesn't remove intermittent issues like page elements not being found and the DOM not being fully formed.

I wanted to investigate whether I can use Selenium as an alternative but am struggling as to how I can:

get Selenium libs to be visible to the Qlikview macro environment
instantiate the Selenium webdriver

I've read some online tutorials regarding automating with Selenium via Excel VBA. In that, the webdriver object needs to be instantiated in similar fashion to this:

Dim driver as Selenium.WebDriver Set driver = New Selenium.WebDriver

In Qlikview macros, all VB variables are created as variants so I suspect that the above isn't possible in a Qlikview macro?

Does anyone have experience of successfully using Selenium from Qlikview macros? Any help would be appreciated.

topic Qlikview Macro - Is it possible to Web automate with Selenium? in App Development

Qlikview Macro - Is it possible to Web automate with Selenium?