Saturday, December 6, 2008

Permission denied: 'CreateObject'

Microsoft VBScript runtime error '800a0046'
Permission denied: 'CreateObject'

The line of code looks like this:

Set xlApp = CreateObject("Excel.Application")

Please Follow these steps :

1. From command prompt type "dcomcnfg.exe"

2. You will see ‘Component Management’ window

3. Component Services --> Computer--> My Computer--> DComConfig

4. From the tree view select ‘Microsoft Excel Application’

5. Right-Click on it & select ‘Properties’

6. From the property window select the ‘Security’ tab.

7. Then for all the three options select ‘Customize’ Radio button (or according to your need)

8. Add ‘ASPNET’ or IUSR_Machine (IIS account) account to all the three

9. Give appropriate permission to them

10. Then click Apply.

Hope It Helps !!
Bhaskar Ghosh

1 comment:

Anonymous said...

I think that you may be interested in another application that quickly eliminates data corruption issues in database files, please take a look at dbase fix tool and let me know what do you think