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

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

This is a tricky one, which can be solved if the following three things are configured:

1. Make sure that Excel is installed on your server

It is needed for the license.

2. Make sure the permissions are set correctly for the Excel application. This thread explains how:

http://forums.devarticles.com/microsoft-access-development-49/permission-denied-when-access-excel-obj-5801.html

3. Make sure that unsigned ActiveX controls are not blocked by your browser:

In Internet Explorer. Go to, Tools -> Internet Options

Click on the 'Security' tab

Then seek the following:


'Download unsigned ActiveX controls'
- Set to 'Prompt'


Initialize and script ActiveX controls not marked as safe
- Set to 'Prompt'