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

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 browswer:

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'