topic Re: Macro parse failed error massage in QlikView

Macro parse failed error massage

dafnis14 — Wed, 04 Feb 2015 12:43:17 GMT

Hi,

After upgrading to ver. 11.2, SR9, clients are getting an error message when trying to execute a macro which triggers another macro in an excel sheet.

Running the macro from a desktop works fine, on the server as well as on a desktop.

Does anyone have a clue?

Thanks!

Re: Macro parse failed error massage

jerrysvensson — Wed, 04 Feb 2015 13:20:03 GMT

The macro code would help.

Re: Macro parse failed error massage

dafnis14 — Wed, 04 Feb 2015 14:13:48 GMT

Hi Jerry,

Here it is:

sub exportTest

set v=ActiveDocument.GetVariable("vReturnFilesPath")

a=v.getcontent.string

set lb = ActiveDocument.GetSheetObject("LB86")

lb.SelectPossible

set cs = ActiveDocument.GetSheetObject("ReturnTemp")

cs.ExportEx a & "ReturnTemp.xls" , 5

lb.clear

It works fine with a desktop, on the server or on a client.

Thanks!

Re: Macro parse failed error massage

Anonymous — Wed, 04 Feb 2015 14:17:08 GMT

so where is the problem if not on the server or desktop...??

also - my guess is that it fails at the exportex point.....test if this is true by putting a msgbox just before that line...

Re: Macro parse failed error massage

dafnis14 — Thu, 05 Feb 2015 06:44:19 GMT

Hi,

As I said, the error occures only when a user opens the application in server (i.e., client mode).

The tip about the msgbox was helpful..

The error is caused by the line : lb.clear.

Can you figure why it happens only in the client mode?

Thanks!

Re: Macro parse failed error massage

marcus_sommer — Thu, 05 Feb 2015 09:09:38 GMT

Have you checked the server-settings within the qmc in tab security "Allow (unsafe) macro ..."?

- Marcus

Re: Macro parse failed error massage

jerrysvensson — Thu, 05 Feb 2015 09:39:51 GMT

Have you tried:

sub exportTest

dim lb

set lb = ActiveDocument.GetSheetObject("LB86")

lb.SelectPossible

MsgBox "Before clear")

lb.clear

MsgBox "After clear")

end sub

Re: Macro parse failed error massage

dafnis14 — Thu, 05 Feb 2015 11:37:33 GMT

Hi,

I have removed the lb.clear altogether, and the issue was resolved...for the time being..

Re: Macro parse failed error massage

Anonymous — Thu, 05 Feb 2015 18:17:03 GMT

assuming all other contingencies are satisfied (i.e. server settings, security settings, etc.)...

try putting this just before the "lb.clear" statement

activedocument.getapplication.waitforidle

I couldn't reproduce the error you're getting on my server in a test app so if the above doesn't work...my only guess would be that its related to something environment specific with the user...

Re: Macro parse failed error massage

dafnis14 — Sun, 08 Feb 2015 09:21:51 GMT

Thanks.. good to know about such option!