September 6, 2008 02:17pm pdt

1. TheLearn... 201,359
2. jaime_oliv... 177,837
3. jpaulino 141,495
4. Dhaest 130,766
5. Idle_Mind 113,194
6. Fernando... 104,965
7. angelIII 97,415
8. emoreau 95,478
9. ZachSmith 89,365
10. PaulHews 88,152
11. graye 84,050
12. Sancler 82,419
13. jcoehoorn 69,670
14. naspinski 60,130
15. webtubbs 58,743
16. VBRocks 57,125
17. vb_jonas 55,375
18. Mikal613 53,025
19. GreenGho... 51,947
20. rachitkohli 48,214
21. JimBrandley 41,514
22. nsanga 41,340
23. BillyDvD 41,102
24. raterus 40,750
25. surajguptha 40,350

1. TheLearn... 1,784,512
2. iboutchkine 802,468
3. mmarinov 554,677
4. Idle_Mind 551,505
5. gregoryyo... 491,841
6. emoreau 465,535
7. naveenko... 451,699
8. testn 352,601
9. YZlat 332,657
10. RobertRFr... 331,569
11. jaime_oliv... 330,597
12. Fernando... 305,980
13. AlexFM 304,664
14. graye 304,413
15. surajguptha 302,620
16. Dhaest 278,966
17. Arthur_... 274,504
18. Mikal613 243,358
19. jpaulino 230,207
20. _TAD_ 216,929
21. roverm 215,141
22. angelIII 213,733
23. GoodJun 196,004
24. EBatista 190,414
25. ihenry 189,151

05.13.2008 at 01:23PM PDT, ID: 23399307

	[x] Attachment Details

cannot create Excel ActiveX component in VB.NET

Asked by Terrace in .NET, DCOM

Tags: VB.NET

I know this issue is very common, so I read bunch of articles and tried many things, but still no luck.

I have a web application in VB.NET that is using Excel Automation.
This setup succesfully worked for last few months, but last week I had to re-formatt our server due to virus attack.

I reinstalled my IIS, re installed my website, etc.
I also re-installed Microsoft Office 2003

I referenced Microsoft Excel 11.0 Object Library and Microsoft Office 11.0 Object Library in my >NET project

When I run my code I get an error: System.Exception: Cannot create ActiveX component.

The line of code where error is happening is: xlsApp1 = CreateObject("Excel.Application")

So, I did not change anything in my code. It was working great before.

I am not sure what I am missing.

I ensured that my ASPNET, IUSR and IWAM have permissions to Launch and Access Excel in DCOM Config.
I even set IUSR and IWAM to be members of Administrators Group - still no luck

What am I missing?

Thanks

Start Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:

           
           
             'Access Excel Object and start Application manipulations
        Dim oExcel As Object
        Dim oBook As Object
        Dim oSheet As Object
 
        Dim xlsApp1 As Object
        Dim xlsBook1 As Object
        Dim xlsSheet1 As Object
 
        Dim xlsBook2 As Object
        Dim xlsSheet2 As Object
 
        Dim sSampleFolder = "C:\Rates\"
 
        'Start a new workbook in Excel.
        xlsApp1 = CreateObject("Excel.Application")
        xlsApp1.Visible = False
        xlsApp1.DisplayAlerts = False

           
         

Keywords: cannot create Excel ActiveX compone…

	Title
1	ActiveX component can't create obje…
2	ActiveX control passing structure/obj…
3	Properly Self Terminate ActiveX exe
4	Create an ActiveX control with VB.net
5	Creating activeX for HTMl like Applets
6	Capture ActiveX events with Javascript

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

cannot create Excel ActiveX component in VB.NET

Asked by Terrace in .NET, DCOM

Tags: VB.NET

About this solution