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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
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