PC Review


Reply
Thread Tools Rating: Thread Rating: 2 votes, 1.00 average.

ASP.Net won't allow Creation of Excel

 
 
=?Utf-8?B?TWFyaw==?=
Guest
Posts: n/a
 
      10th Aug 2005


VB Code
Dim xlApp As Microsoft.Office.Interop.Excel.Application

'Open Excel Application
xlApp = CreateObject("Excel.Application") ' ***** Blows up here
*****

Error Exception Details
System.Exception: Cannot create ActiveX component.

Stack

 
Reply With Quote
 
 
 
 
=?Utf-8?B?QW5hbmRbTVZQXQ==?=
Guest
Posts: n/a
 
      11th Aug 2005
Do you have excel installed on that machine??

--
Rgds,
Anand
VB.NET MVP
http://www.dotnetindia.com


"Mark" wrote:

>
>
> VB Code
> Dim xlApp As Microsoft.Office.Interop.Excel.Application
>
> 'Open Excel Application
> xlApp = CreateObject("Excel.Application") ' ***** Blows up here
> *****
>
> Error Exception Details
> System.Exception: Cannot create ActiveX component.
>
> Stack
>

 
Reply With Quote
 
=?Utf-8?B?TWFyaw==?=
Guest
Posts: n/a
 
      12th Aug 2005
Yes it is installed.

How can I get ASP.Net to recognize it and open it? (specifics are very
helpful, as I am not a guru with security, etc.)

Thanks
Mark

"Anand[MVP]" wrote:

> Do you have excel installed on that machine??
>
> --
> Rgds,
> Anand
> VB.NET MVP
> http://www.dotnetindia.com
>
>
> "Mark" wrote:
>
> >
> >
> > VB Code
> > Dim xlApp As Microsoft.Office.Interop.Excel.Application
> >
> > 'Open Excel Application
> > xlApp = CreateObject("Excel.Application") ' ***** Blows up here
> > *****
> >
> > Error Exception Details
> > System.Exception: Cannot create ActiveX component.
> >
> > Stack
> >

 
Reply With Quote
 
=?Utf-8?B?QW5hbmRbTVZQXQ==?=
Guest
Posts: n/a
 
      12th Aug 2005
From the error you got it does not seem to be a security problem. I would
suspect Excel not being correctly registered. Are you able to create an Excel
object from a normal winform application running on the machine where the web
server is installed?

--
Rgds,
Anand
VB.NET MVP
http://www.dotnetindia.com


"Mark" wrote:

> Yes it is installed.
>
> How can I get ASP.Net to recognize it and open it? (specifics are very
> helpful, as I am not a guru with security, etc.)
>
> Thanks
> Mark
>
> "Anand[MVP]" wrote:
>
> > Do you have excel installed on that machine??
> >
> > --
> > Rgds,
> > Anand
> > VB.NET MVP
> > http://www.dotnetindia.com
> >
> >
> > "Mark" wrote:
> >
> > >
> > >
> > > VB Code
> > > Dim xlApp As Microsoft.Office.Interop.Excel.Application
> > >
> > > 'Open Excel Application
> > > xlApp = CreateObject("Excel.Application") ' ***** Blows up here
> > > *****
> > >
> > > Error Exception Details
> > > System.Exception: Cannot create ActiveX component.
> > >
> > > Stack
> > >

 
Reply With Quote
 
Michael D. Ober
Guest
Posts: n/a
 
      13th Aug 2005

Take a look at the NTFS permissions on the directory with excel.exe in it.
I suspect the ASP login doesn't have privs to this directory. I ran into
similar problems with straight ASP and that was the solution.

Mike Ober.

"Anand[MVP]" <(E-Mail Removed)> wrote in message
news:B07A6B81-9A2D-4E64-B4DF-(E-Mail Removed)...
> From the error you got it does not seem to be a security problem. I would
> suspect Excel not being correctly registered. Are you able to create an

Excel
> object from a normal winform application running on the machine where the

web
> server is installed?
>
> --
> Rgds,
> Anand
> VB.NET MVP
> http://www.dotnetindia.com
>
>
> "Mark" wrote:
>
> > Yes it is installed.
> >
> > How can I get ASP.Net to recognize it and open it? (specifics are very
> > helpful, as I am not a guru with security, etc.)
> >
> > Thanks
> > Mark
> >
> > "Anand[MVP]" wrote:
> >
> > > Do you have excel installed on that machine??
> > >
> > > --
> > > Rgds,
> > > Anand
> > > VB.NET MVP
> > > http://www.dotnetindia.com
> > >
> > >
> > > "Mark" wrote:
> > >
> > > >
> > > >
> > > > VB Code
> > > > Dim xlApp As Microsoft.Office.Interop.Excel.Application
> > > >
> > > > 'Open Excel Application
> > > > xlApp = CreateObject("Excel.Application") ' ***** Blows up

here
> > > > *****
> > > >
> > > > Error Exception Details
> > > > System.Exception: Cannot create ActiveX component.
> > > >
> > > > Stack
> > > >

>




 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Guidance on automating the creation of Excel files from Excel LetMeDoIt Microsoft Excel Programming 1 20th Jul 2007 07:23 AM
Excel / XMI Creation dvhirst Microsoft Excel Misc 0 11th Jun 2007 06:13 PM
Excel documents not saving in Excel after creation or transfer. =?Utf-8?B?R3JhZCBTY2hvb2wgTW9t?= Microsoft Excel Misc 3 25th Aug 2006 01:49 AM
ASP Dynamic Excel Creation Chris Oswald Microsoft Excel Programming 0 9th Nov 2004 05:27 PM
Form creation exception error; swapping delaying object creation? Fiona McBride Microsoft Dot NET 0 20th Apr 2004 09:58 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:37 PM.