need help

[#1]

how to use macros for converting into excel and pdf reports?

[sujeetsingh]

QlikView Macro

[ankit777]

The following macros code creates the Excel sheet in correct format during reload of the script.

sub Export

set obj1 = ActiveDocument.GetSheetObject("TB01")

obj1.ExportBiff "C:\Documents and Settings\User\Desktop\InnerJoin.xls"

msgbox("Done")

end sub

regards

Ankit

[#4]

Hi,

For pdf, you can refer to these discussion:

http://community.qlik.com/message/254341 or

http://community.qlik.com/message/428429

For excel:

http://community.qlik.com/message/418334

Hope this helps!

[vikasmahajan]

PFA sample.

Vikas