topic Re: need help in QlikView

need help

Mon, 13 Jan 2014 04:53:48 GMT

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

sujeetsingh — Mon, 13 Jan 2014 04:55:20 GMT

ankit777 — Mon, 13 Jan 2014 05:36:08 GMT

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

Mon, 13 Jan 2014 05:53:09 GMT

Hi,

For pdf, you can refer to these discussion:

For excel:

Hope this helps!

vikasmahajan — Mon, 13 Jan 2014 05:57:02 GMT

PFA sample.

Vikas