Solved: Re: Error in Macro script - Qlik Community

Report Inappropriate Content · ‎2013-10-17

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.

marcus_sommer · ‎2013-10-18

This is your (reduced) code which worked:

sub ExcelFile

Set myApp = CreateObject ("Outlook.Application")

Set myMessage = myApp.CreateItem(olMailItem)

myMessage.BodyFormat = 3 'Outlook.OlBodyFormat.olFormatRichText

myMessage.To = "marcus.sommer@md.de"

myMessage.Subject = "Test File " & Date()

myMessage.Send

Set myMessage = Nothing

Set myApp = Nothing

end sub

Generally will be an outlook-mail opened?

- Marcus

View solution in original post

MayilVahanan · ‎2013-10-17

Hi

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

Report Inappropriate Content · ‎2013-10-17

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

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

Any Example would help.

MayilVahanan · ‎2013-10-17

HI

Quick Question:

In your machine, excel installed?

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

Report Inappropriate Content · ‎2013-10-17

Yes Excel 2010

MayilVahanan · ‎2013-10-17

Hi

Please refer this

Re: Exporting to multiple Tabs of the same Excel file

Output Multiple Pivots to Excel

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

Report Inappropriate Content · ‎2013-10-18

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

CELAMBARASAN · ‎2013-10-18

Is your excel is licensed one? or starter pack?

I hope Excel.Application wont work in starter pack.

Report Inappropriate Content · ‎2013-10-18

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.

CELAMBARASAN · ‎2013-10-18

on opening itself it will show Excel Starter 2010.