pls check the macro code

Thu, 23 Jun 2011 05:31:35 GMT

Hi to all,

how to create a new variable in another QVW file by using macro.

I tried like this but it showing error. What i should modify in below code.

Sub NewVar

set UserFile = App.OpenDoc ("Mydoc123.qvw","","")

set v2 =UserFile.CreateVar("vGet")

ActiveDocument.ClearAll false

End Sub

Pls any one can share your experience on this.

Regards

Venkat

kaushiknsolanki — Thu, 23 Jun 2011 07:01:00 GMT

Hi,

Use below code.

Sub NewVar

set App = ActiveDocument.GetApplication
set UserFile = App.OpenDoc ("Mydoc123.qvw","","")

UserFile.CreateVariable "vGet"

End Sub

Regards,

Kaushik Solanki

topic pls check the macro code in QlikView