topic Macro- Question in QlikView

Macro- Question

Mon, 06 May 2013 21:34:55 GMT

Hi,

I am a newbie to QV and Macro world. Please bear with me if this is a silly question. I have created a qlikview document with two sheets sheet1 and sheet2 and each sheet has bunch of charts. I have a created a macro to export the charts from sheet 1 and it works fine. The issue I am facing is when I try to create a macro for the second sheet, the code I put in is overwriting the code on macro 1 on sheet 1. so is there a way to isolate the two macros? is there a better way of doing this? Please help

Re: Macro- Question

Gysbert_Wassenaar — Tue, 07 May 2013 06:19:46 GMT

There's only one module per document to put macro code in. You need to give the different macro's their own name and use those names to call the macros.

Sub ExportSheet1

...do sheet1 export stuff here...

end Sub

Sub ExportSheet2

...do sheet2 export stuff here...

end Sub

Re: Macro- Question

Siva_Sankar — Tue, 07 May 2013 07:09:29 GMT

Hi, Attached the qvw file. Look and let me know is that you want. Regards. Siva

Re: Macro- Question

Tue, 07 May 2013 13:27:42 GMT

Siva,

I am on personal edition so cannot open the Qvws created by others. Can you please put your code here in this thread? Appreciate your help.

Re: Macro- Question

Tue, 07 May 2013 13:29:06 GMT

Issue is I am unable to export charts on sheet2 when I put everything in the same module. May be I am missing something.

Re: Macro- Question

anandathome — Tue, 07 May 2013 14:38:26 GMT

Hi Arjun,

You can find relevant code at:

http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/

This should really help you.

-Anand.

Re: Macro- Question

Siva_Sankar — Wed, 08 May 2013 04:42:30 GMT

sub exportToFolder ChartPath = "D:\QV Export" ActiveDocument.GetSheetObject( "CH01").ExportBitmapToFile ChartPath & "B.jpg" ActiveDocument.GetSheetObject( "CH02").ExportBitmapToFile ChartPath & "D.jpg" end sub