Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Friends,
I would like to read the variable and assigned value in the QV macro.
For instance, In a pivot table and I have 35 rows, using NoOfRows() function I can store the value in a X variable.
But I would like to use the same variable in VB marco, when I try to print the variable it shows nothing.
Could you please anyone tell me how do I read the variable in the Edit module.
Thanks and Regards
Chriss
Hi,
Following is the code for accessing Varibale in Macro
set v = ActiveDocument.GetVariable("Variable1")
abc = v.GetContent.String
Cheers
Regards,
Kaushik Solanki
Hello Kaushik,
Thanks a lot....
Regards
Chriss