Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
vipin_mishra479
Creator II
Creator II

Macro error ActiveX component can't create object: 'Outlook.Application'

Hi All,

sub OvrallCstAnlysis

        Set vOlApp = CreateObject("Outlook.Application")

        Set vMessage = vOlApp.CreateItem(olMailItem)

ActiveDocument.Sheets("Overall Cost  Analysis").Activate

        set image = ActiveDocument.GetSheetObject ("CH10126")

ActiveDocument.GetApplication.WaitForIdle

image.CopyBitmapToClipboard

vMessage.GetInspector.WordEditor.Range.Paste

        vMessage.Subject = "Overall Cost  Analysis"

        vMessage.Display

end sub

Here i face problem ActiveX component can't create object: 'Outlook.Application'  when i run this macro in office 13

but when i run this macro in office 10 its work properly.

please help

4 Replies
Anonymous
Not applicable

Please check if you have selected option,

Allow system access and allow all macros.

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Make sure you don't have Outlook running. And you can try CreateObject("Outlook.Application.14")


talk is cheap, supply exceeds demand
vipin_mishra479
Creator II
Creator II
Author

hi, thanx for reply.

But it is still giving same error as ActiveX component can't create object: 'Outlook.Application.14'

vipin_mishra479
Creator II
Creator II
Author


hi,

it is already selected