topic Re: Error in Macro script in QlikView

Error in Macro script

Thu, 17 Oct 2013 14:26:43 GMT

Hi,

Can anyone please have a look on attached and when I am clicking ok the macro it is hightlighting

Email=v.GetContent.String and showing

Object Required=v

Please can anyone let me know is there any error in macro.

Re: Error in Macro script

MayilVahanan — Thu, 17 Oct 2013 14:37:46 GMT

May be the EmailAddress variable is not available.
Please check once.

Re: Error in Macro script

Thu, 17 Oct 2013 14:42:48 GMT

Thanks and I set EmailAddress variable. now it's showing

ActiveX component can't create object: 'Excel.Application'

Any Example would help.

Re: Error in Macro script

MayilVahanan — Thu, 17 Oct 2013 14:48:54 GMT

Quick Question:

In your machine, excel installed?

Re: Error in Macro script

Thu, 17 Oct 2013 14:52:58 GMT

Yes Excel 2010

Re: Error in Macro script

MayilVahanan — Thu, 17 Oct 2013 15:05:35 GMT

Please refer this

Re: Exporting to multiple Tabs of the same Excel file

Output Multiple Pivots to Excel

Re: Error in Macro script

Fri, 18 Oct 2013 13:15:23 GMT

Thanks still showing the same error as ActiveX component can't create object: 'Excel.Application'
Any help lease.

Re: Error in Macro script

CELAMBARASAN — Fri, 18 Oct 2013 13:23:14 GMT

Is your excel is licensed one? or starter pack?

I hope Excel.Application wont work in starter pack.

Re: Error in Macro script

Fri, 18 Oct 2013 13:24:12 GMT

Hi,

How can I know whether is it licenced or starter pack? and also I am trying to write macro on qlikview personal edition before implementing in server.

Re: Error in Macro script

CELAMBARASAN — Fri, 18 Oct 2013 13:27:31 GMT

on opening itself it will show Excel Starter 2010.

Re: Error in Macro script

marcus_sommer — Fri, 18 Oct 2013 13:29:24 GMT

License-information: press button help - about qv. But I think this the reason is the security settings within the macro-editor - it must be set on access to extern files (on the left side).

- Marcus

Re: Error in Macro script

Fri, 18 Oct 2013 13:33:01 GMT

It's showing excel 2010 when I am clikcking excel icon. is that you mean?

Re: Error in Macro script

marcus_sommer — Fri, 18 Oct 2013 13:37:20 GMT

No sorry, I meant the license from qv - but cause are security settings, first in macro-editor from qv.

- Marcus

Re: Error in Macro script

Fri, 18 Oct 2013 13:38:28 GMT

ok that means if I run macro in licenced qv server will it work?

Re: Error in Macro script

MayilVahanan — Fri, 18 Oct 2013 13:43:31 GMT

Did you set

Requested Module Security -> System Access

Current Local Security -> Allow System Access?

Re: Error in Macro script

Fri, 18 Oct 2013 13:47:41 GMT

Thanks very much it's working but just showing below when I am executing

There must be at least one name or contact group in the To, Cc, or Bcc box.

please let me know is it possible to solve this one

Re: Error in Macro script

marcus_sommer — Fri, 18 Oct 2013 13:54:23 GMT

myMessage.To = Email - the variable must be a valid mail, perhaps it is empty.

- Marcus

Re: Error in Macro script

Fri, 18 Oct 2013 14:04:45 GMT

Thanks and it is showing at

mymessage.send

please any help.

Re: Error in Macro script

marcus_sommer — Fri, 18 Oct 2013 14:14:51 GMT

For me it worked - but there is an addional security message from outlook like this:

- Marcus

Re: Error in Macro script

Fri, 18 Oct 2013 14:20:39 GMT

for me it's not any help please.