topic Macro parse failed. Functionality was lost in QlikView

Macro parse failed. Functionality was lost

Mon, 26 Jan 2026 18:19:17 GMT

In Plugin IE version 8.2, my macro work well.

But with V8.5 of ie plugin i have the error : "Macro parse failed. Functionality was lost"

I have this code. It's for open a sheet with a button.

sub

openSheet ( pIDPar )

' Ouverture du Sheet

Set

Set s = ActiveDocument.ActivateSheet("Document" & pIDPar)

Set

end

call

openSheet("SH_MAIN")

end

sub sub

sub

LaunchMain

Thx

Macro parse failed. Functionality was lost

Mon, 11 May 2009 22:58:30 GMT

Could you rewrite your function because the format does not allow us to read it correcty.

Macro parse failed. Functionality was lost

Tue, 12 May 2009 13:31:56 GMT

sub openSheet ( pIDPar )
' Ouverture du Sheet
Set s = ActiveDocument.ActivateSheet("Document\" & pIDPar)
end sub

sub LaunchMain

call openSheet("SH_MAIN")

end sub

Macro parse failed. Functionality was lost

Tue, 12 May 2009 14:34:37 GMT

Replace your code by

sub openSheet ( pIDPar )
' Ouverture du Sheet
ActiveDocument.ActivateSheet(pIDPar)
end sub

sub LaunchMain

call openSheet("SH_MAIN")

end sub

Rgds,

Macro parse failed. Functionality was lost

Tue, 12 May 2009 15:32:29 GMT

I test it but it don't work.

I have another macro wich work well and use ActiveDocument :

set t = ActiveDocument.Variables("varTEST")
t.SetContent vTypePar, true

Only try to activate a Sheet make problem!

Rgds,

Macro parse failed. Functionality was lost

Tue, 12 May 2009 16:19:45 GMT

Are you sure that the sheet SH_MAIN exists ?

I tried the macro on my document and it worked...

Macro parse failed. Functionality was lost

Tue, 12 May 2009 18:09:09 GMT

Yes the sheet exist. => The problem is on several sheets.

With IE PLUG IN in version 8.2 it's ok but not in 8.5.

Macro parse failed. Functionality was lost

Tue, 12 May 2009 18:50:30 GMT

Hi,

Have you checked the Module Security within the QV plugin?
When you've opened the QVW file in the IE plugin, press CTRL+SHIFT+M.
Then choose: Give System Access to Module script.

Greetz
Robbie

Macro parse failed. Functionality was lost

Mon, 29 Jun 2009 22:31:53 GMT

I find it.

The qlikview server have been installed in 8.2 version and i develop in 8.5 version.

I change the function

ActiveDocument.ActivateSheet pIDPar

ActiveDocument.ActivateSheetByID pIDPar

It's work with 8.5 pluq-in but not in 8.2 😉

But now the qlikview server is in 8.5 too.

Thank you