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'
this really works..thanks a lot
ReplyDeleteThanks it worked
ReplyDeleteThank you. You are the first to finally help me with my problem. Step 3 is what worked for me.
ReplyDeleteIs it not possible to interact with the Excel file WITHOUT the Excel pacakge being installed.
ReplyDeletei.e. To avoid red-tape with Client over licensing of Excel on our test server?
thank you a lot
ReplyDeleteThank you. It worked
ReplyDeletethank you really help
ReplyDelete