VB script and IE Qlikview will run in excel 2010 but not 2013

[tinkerz1]

Hi,

I have a user with 2010 excel using IE and Qlikview plugin, the script works on 2010 but has a subscript error in 2013.

The both access the same reports on the server.

Any ideas to the difference between the two?

Thanks,

Tinkerz1

[marcus_sommer]

What does these macro do and how looked the error-message?

- Marcus

[ThornOfCrowns]

Check that the project has the correct dependencies for the version it's running on:

e.g.

[tinkerz1]

The user also has a local copy of qlikview installed and can use macros using that program.

The VB script is the same, still looking into it, I will post the error message shortly.

[tinkerz1]

Will the QV plugin run macros in 64bit excel? I have 32 bit machine and I can run macros from the server.

But other users on 64bit cant run macros, is this the issue?

[marcus_sommer]

Your excel 2013 user had a 64-bit installation of MS excel/office? If yes, I think this will be the reason why it not worked.

(AFAIK there is no official recommendation from MS to use a 64-bit office-installation)

- Marcus

[tinkerz1]

So let me get this right, the server and plugin is 32bit, and that needs a 32bit version of excel?

But the local installation is 64 bit and thats ok for 64bit excel.

Is that right?

Is it possible to set excel up in 32bit mode on a 64bit machine?

[marcus_sommer]

AFAIK the plugin is only as a 32-bit version available. But this isn't a problem then windows as OS and the most 64-bit programs could be handle 32-bit programs/threads very well but the reversed direction don't worked.

This meant you could install a 32-bit office within a 64-bit windows.

- Marcus

[tinkerz1]

The error is

QlikOCX

Macro parse failed: Functionalitiy was lost.

MyMacroName

Error:Subscript out of range

This macro works on access point and 32 bit machines

[marcus_sommer]

This error indicates that a certain allocation is wrong: Subscript out of range (Error 9). You could try with the using of msgbox to find which part of the script throws the error out. I mean:

sub x

msgbox 1

.... some statements

msgbox 2

.... other statements

msgbox 3

... and so on ...

end sub

And you need to check that not a 64-bit excel is installed.

- Marcus