Lee Remsbery
New Member
- Joined
- Dec 10, 2008
- Messages
- 6
Hope you can assist with a problem I am experiencing.
My work have recently re-placed all the PC’s in the office from Windows 7 to Windows 10, as such certain vba code now fails to run within Excel routines
The Code in question was ‘emailing a specific excel sheet via Outlook’ which previously worked well
The error occurs when the code reached this piece of code
Dim OutApp As Object
More code
Set OutApp = CreateObject("Outlook.Application").
Code stops here with an error msg such as ‘Unable to launch ActiveX control’
Any idea’s……… Your assistance would be greatly appreciated
My work have recently re-placed all the PC’s in the office from Windows 7 to Windows 10, as such certain vba code now fails to run within Excel routines
The Code in question was ‘emailing a specific excel sheet via Outlook’ which previously worked well
The error occurs when the code reached this piece of code
Dim OutApp As Object
More code
Set OutApp = CreateObject("Outlook.Application").
Code stops here with an error msg such as ‘Unable to launch ActiveX control’
Any idea’s……… Your assistance would be greatly appreciated
Last edited:
