Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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

Not applicable
Author

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


sub LaunchMain

call openSheet("SH_MAIN")

end sub

Not applicable
Author

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
Author

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
Author

Are you sure that the sheet SH_MAIN exists ?

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

Not applicable
Author

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
Author

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
Author

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 😉

But now the qlikview server is in 8.5 too.

Thank you