Macro creation in the format specified!!

[abhishek_bigdat]

Hi,

I have created a pivot table and generated a report and macro is generated in the qlikview generated format. Can anyone help me in writing a vbscript for generation of macro in the specified format!!