Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Macro parse failed. Functionality was lost





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





8 Replies
Not applicable

Macro parse failed. Functionality was lost

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

Not applicable

Macro parse failed. Functionality was lost

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


sub LaunchMain

call openSheet("SH_MAIN")

end sub

Not applicable

Macro parse failed. Functionality was lost

Replace your code by

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


sub LaunchMain

call openSheet("SH_MAIN")

end sub

Rgds,


Not applicable

Macro parse failed. Functionality was lost

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,

Not applicable

Macro parse failed. Functionality was lost

Are you sure that the sheet SH_MAIN exists ?

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

Not applicable

Macro parse failed. Functionality was lost

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.

Not applicable

Macro parse failed. Functionality was lost

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

Not applicable

Macro parse failed. Functionality was lost

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



BY

ActiveDocument.ActivateSheetByID pIDPar

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

But now the qlikview server is in 8.5 too.

Thank you



Community Browser