Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
shyamcharan
Creator III
Creator III

Vb Script Error Wrong number of arguements or Invalid property

Hi Experts,

I am trying to use the below script in the QlikView Edit Module page of Run Macro action bution.

I believe this code is to reload the dashbaord. However, I am getting the below error:

Wrong number of arguments or invalid property assignment: 'ActiveDocument'

Can anyone please suggest what am I doing wrong?

Set MyApp = CreateObject("QlikTech.QlikView")

Set MyDoc = MyApp.OpenDoc ("O:\Office\Admin & Misc\NSWTEAM\Mainpac_DWS\QVSource\TestQVSource.qvw","","")

Set ActiveDocument = MyDoc

ActiveDocument.Reload

Set Button1 = ActiveDocument.GetSheetObject("BU01")

Button1.Press

MyDoc.GetApplication.Quit

Set MyDoc = Nothing

Set MyApp = Nothing

Regards,

Shyam

0 Replies