topic Re: Multiple macros execution on single button click in QlikView

Multiple macros execution on single button click

swati_rastogi27 — Mon, 11 Apr 2016 08:40:18 GMT

Hi all ,

Can we not execute 2 macros on a single button click.

I have written below code to capture screenshot of a particular sheet object:

public function ExportImage

ActiveDocument.GetApplication.WaitForIdle

ActiveDocument.GetSheetByID("SH06").Activate

vFolder = ActiveDocument.GetVariable("vExportFolder").GetContent().String

ActiveDocument.GetApplication.WaitForIdle

set obj = ActiveDocument.GetSheetObject("CH167")

ActiveDocument.GetApplication.WaitForIdle

fileName = "Report_" & replace(replace(replace(date() & "_" & time(), "/", ""), ".", ""), ":", "") & ".png"

ActiveDocument.GetApplication.WaitForIdle

obj.ExportBitmapToFile vFolder & fileName

end function

If I write another macro to similarly capture screenshot of another object, now nothing happens and the Edit module pops up.

Where am I going wrong?

Re: Multiple macros execution on single button click

jonathandienst — Mon, 11 Apr 2016 09:19:18 GMT

I suggest that you post the entire macro code, rather than the part that works.

Re: Multiple macros execution on single button click

swati_rastogi27 — Mon, 11 Apr 2016 09:20:14 GMT

Also , I tried to create 2 separate buttons to capture screenshot, but when I change the code in one button macro, the other one also gets affected.

How can I avoid this?

Re: Multiple macros execution on single button click

tamilarasu — Mon, 11 Apr 2016 09:23:40 GMT

Hi,

Try this,

Public function ExportImage

ActiveDocument.GetApplication.WaitForIdle

ActiveDocument.GetSheetByID("SH06").Activate

vFolder = ActiveDocument.GetVariable("vExportFolder").GetContent().String

ActiveDocument.GetApplication.WaitForIdle

set obj = ActiveDocument.GetSheetObject("CH167")

ActiveDocument.GetApplication.WaitForIdle

fileName = "Report_" & replace(replace(replace(date() & "_" & time(), "/", ""), ".", ""), ":", "") & ".png"

ActiveDocument.GetApplication.WaitForIdle

obj.ExportBitmapToFile vFolder & fileName

'**************************************************************

Second export chart ID

set obj = ActiveDocument.GetSheetObject("CH01")

ActiveDocument.GetApplication.WaitForIdle

fileName = "Report_" & replace(replace(replace(date() & "_" & time()+1, "/", ""), ".", ""), ":", "") & ".png"

obj.ExportBitmapToFile vFolder & fileName

'**************************************************************

end function

Re: Multiple macros execution on single button click

tamilarasu — Mon, 11 Apr 2016 14:19:30 GMT

First button Macro:

Change the function name as ExportImage1.

public function ExportImage1

ActiveDocument.GetApplication.WaitForIdle

ActiveDocument.GetSheetByID("SH06").Activate

vFolder = ActiveDocument.GetVariable("vExportFolder").GetContent().String

ActiveDocument.GetApplication.WaitForIdle

set obj = ActiveDocument.GetSheetObject("CH167")

ActiveDocument.GetApplication.WaitForIdle

fileName = "Report_" & replace(replace(replace(date() & "_" & time(), "/", ""), ".", ""), ":", "") & ".png"

ActiveDocument.GetApplication.WaitForIdle

obj.ExportBitmapToFile vFolder & fileName

end function

***************************************

Second button Macro:

Change the function name as ExportImage2 and chart ID as per your requirement..

public function ExportImage2

ActiveDocument.GetApplication.WaitForIdle

ActiveDocument.GetSheetByID("SH06").Activate

vFolder = ActiveDocument.GetVariable("vExportFolder").GetContent().String

ActiveDocument.GetApplication.WaitForIdle

set obj = ActiveDocument.GetSheetObject("CH01") 'your second chart ID

ActiveDocument.GetApplication.WaitForIdle

fileName = "Report_" & replace(replace(replace(date() & "_" & time(), "/", ""), ".", ""), ":", "") & ".png"

ActiveDocument.GetApplication.WaitForIdle

obj.ExportBitmapToFile vFolder & fileName

end function

Re: Multiple macros execution on single button click

Peter_Cammaert — Mon, 11 Apr 2016 15:39:46 GMT

Macro objects are defined for your entire document, not just for a single button or object. If you change a macro name by editing it in the actions dialog of one button, it will have changed for all actions that rely on this macro.