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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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