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