topic Re: Macro Troubleshooting in QlikView

Macro Troubleshooting

marksmunich — Wed, 10 Sep 2014 07:29:23 GMT

Hello community,

I am running a macro in my qlikview document and i have a Trigger on a button.

I have the following code in the macro module:

This works fine when i click on the test in the edit module console, but it doesnt work when i click on the button, I have also made Setting in the document properties Macro override security and also in macro edit module I have set requested module securit to System Access and also current local security. Is there any mistake in this process. btw i got this code from the community. what is this SUB callexample after the function. Do i Need to replace it with my qvw document Name or just leave it as it is.

FUNCTION ExcelExport(objID)

set obj = ActiveDocument.GetSheetObject( objID )

w = obj.GetColumnCount

if obj.GetRowCount>1001 then

h=1000

else h=obj.GetRowCount

end if

Set objExcel = CreateObject("Excel.Application")

objExcel.Workbooks.Add

objExcel.Worksheets(1).select()

objExcel.Visible = True

set CellMatrix = obj.GetCells2(0,0,w,h)

column = 1

for cc=0 to w-1

objExcel.Cells(1,column).Value = CellMatrix(0)(cc).Text

objExcel.Cells(1,column).EntireRow.Font.Bold = True

column = column +1

c = 1

r =2

for RowIter=1 to h-1

for ColIter=0 to w-1

objExcel.Cells(r,c).Value = CellMatrix(RowIter)(ColIter).Text

c = c +1

r = r+1

c = 1

END FUNCTION

SUB CallExample

ExcelExport( "CH06" )

END SUB

Thanks

Mark

Re: Macro Troubleshooting

rajeshvaswani77 — Wed, 10 Sep 2014 07:30:30 GMT

Hi Marks,

Use a msgbox in code to print the values at various points in code.

Will help you debug.

syntax is

msgbox "hello world"

thanks,

Rajesh Vaswani

Re: Macro Troubleshooting

marksmunich — Wed, 10 Sep 2014 07:35:03 GMT

Hi Rajesh,

this makes no difference. I can see the result when iam in the Macro edit module, when i hit test, Excel is generated, but when i Close this macros module and hit on the button in the layout document which has Trigger to run this macro, the Excel is not generated.

Even i see Helloword Msg box, when i test in the macro module.

thanks

Mark

Re: Macro Troubleshooting

rajeshvaswani77 — Wed, 10 Sep 2014 07:42:44 GMT

Hi Mark,

In Macro module. can you make sure that

1) Requested module security is set to System Access

2)Current local security is set to Allow System Access.

thanks,

Rajesh Vaswani

Re: Macro Troubleshooting

jerrysvensson — Wed, 10 Sep 2014 07:42:51 GMT

MsgBox shouldn't make a difference, but by placing them in your code you can see where it fails.

Re: Macro Troubleshooting

rajeshvaswani77 — Wed, 10 Sep 2014 07:43:53 GMT

Also in the QEMC

QlikView Servers, expand and click, Seucrity tab in the right pane "Allow unsafe macro execution on server" and "Allow macro execution on server" ticked) and in the Macro editor, (Ctrl + M, bottom left drop downs)

thanks,

Rajesh Vaswani

Re: Macro Troubleshooting

marksmunich — Wed, 10 Sep 2014 07:48:26 GMT

Jerry Svensson Ya I got the Point. since iam not much familiar with Macro Code, it doesnt help me either.

Rajesh Vaswani :

i have both Settings in macro module enabled.

1) Requested module security is set to System Access

2)Current local security is set to Allow System Access

anyother changes ??

Still it is not working, when i hit ´button on frontend which runs this macro.

Thanks

Mark

Re: Macro Troubleshooting

rajeshvaswani77 — Wed, 10 Sep 2014 08:02:46 GMT

If you made a server side change for,

QEMC

please restart the services.

thanks,

Rajesh Vaswani

Re: Macro Troubleshooting

marksmunich — Wed, 10 Sep 2014 08:06:06 GMT

Even These Options have been enabled before this application is developed. More over this has not been deployed. yet. i am just testing this on the develper tool.

Thanks

Mark

Re: Macro Troubleshooting

rajeshvaswani77 — Wed, 10 Sep 2014 08:14:09 GMT

Is the call in trigger external run macro calling the macro? Comment out all code and just put a message box.

the macro function should be called by just the name in that box.

thanks,

Rajesh Vaswani

Re: Macro Troubleshooting

marksmunich — Wed, 10 Sep 2014 08:35:25 GMT

Rajesh Vaswani : the following is my Approach

I have created a button and it has the following Trigger.

i have clicked on edit module and Input the macro Name.

The following is the code in the Macro module.

I have enabled the following in the macro module.

this is what i did. Since I am not familiar with how macro works, i connot provide you more info.

Thanks

Mark

Re: Macro Troubleshooting

Siva_Sankar — Wed, 10 Sep 2014 09:24:37 GMT

Mark,

Possible to upload your qvw file here?

Re: Macro Troubleshooting

rajeshvaswani77 — Wed, 10 Sep 2014 09:27:32 GMT

your macro takes a input parameter that you are not passing?

Function excelexport(objID)

that seems to be the cause. Can you pass a value there?

Re: Macro Troubleshooting

tresB — Wed, 10 Sep 2014 09:35:40 GMT

In the trigger macro name, put the subroutine name "CallExample" instead of the function name and try.

Re: Macro Troubleshooting

marksmunich — Wed, 10 Sep 2014 09:37:27 GMT

I dont think so, beacuse it is just a function and át the end we are calling the function where we are proving the object id.

Re: Macro Troubleshooting

marksmunich — Wed, 10 Sep 2014 09:41:13 GMT

tresesco : it works now. Thanks a lot for the help.

Rajesh Vaswani : thanks a lot for your efforts in helping me and Response was really quick. thanks once again.

Have a nice day. both.

Re: Macro Troubleshooting

marksmunich — Wed, 10 Sep 2014 13:24:17 GMT

tresesco : any idea how to save this generated Excel document.

thanks.

Re: Macro Troubleshooting

Tue, 16 Sep 2014 13:17:08 GMT

	objExcel.ActiveWorkbook.SaveAs("C:\...\test1.xls")
	objExcel.Quit