topic Re: QlikOcx: Macro parse failed. Problem with .SingleObjectActiveIndex property in QlikView

QlikOcx: Macro parse failed. Problem with .SingleObjectActiveIndex property

Tue, 30 Aug 2011 19:54:33 GMT

I have an application where a user is reporting the following error:

QlikOcx: Macro parse failed. Functionality was lost

Object doesn't support this property or method: 'objProp.SingleObjectActiveIndex'

Using QV 10SP2, running from server, using IE plug-in (works fine with AJAX).

This is not something I've been able to reproduce. When I run via the client, or via IE plug-in on the server or from workstaitons here, the application works fine.

The macro code that spawns the error essentially moves to a particular sheet, then moves to a particular container object. Note that in production, this is in a Sub() where I pass the sheet name, container object ID, and index.

ActiveDocument.ActivateSheet "SheetName"

Set objCont = ActiveDocument.GetSheetObject("CT16")
Set objProp = objCont.GetProperties

ActiveDocument.GetApplication.WaitForIdle

objProp.SingleObjectActiveIndex = 1 ' error here

objCont.SetProperties objProp

On this user's workstation (running same version of plug-in as my machines), the .SingleObjectActiveIndex reference throws the error.

QlikOcx: Macro parse failed. Problem with .SingleObjectActiveIndex property

Sun, 18 Dec 2011 12:12:28 GMT

Hi DHutchins,

some of my users had the same error. We finally figured out that they were using an older version of the IE-Plugin - the Plugin also needs to be updated when you're updating QlikView.

This is especially important for the Container-Object-Index-Variable, since that is unknown in versions < 10 SR 2.

Hope that works for you, too,

Lenka

QlikOcx: Macro parse failed. Problem with .SingleObjectActiveIndex property

Sun, 18 Dec 2011 21:02:28 GMT

Thanks so much, Lenka.

Yes, indeed that was the culprit here, too. While our server is on version 10SR2, this user has 10SR1 plug-in, and it resulted in this error.

Re: QlikOcx: Macro parse failed. Problem with .SingleObjectActiveIndex property

Wed, 06 Mar 2013 13:17:16 GMT

Hi lenka Kruse,

QlikOcx

macro parsed failed Functionality was lost

Export_To_Microsoft_word ' macro name

Error " the file could not be found

("C:\....\standard template.docx") ' I am using this standard template for inserting the data.

Thanks in Advance

Re: QlikOcx: Macro parse failed. Problem with .SingleObjectActiveIndex property

Wed, 06 Mar 2013 22:38:30 GMT

sherbahadur... It appears this is a different issue, and quite possibly you've posted the resolution in your question (file could not be found, etc.).

Do you mind posting more of the routine that is generating this error? Is it just that the code is looking for the standard template.docx file and unable to find?