I was able to get procedure to work in a VB.Net Windows application, and want
to get it to work within a ASP.Net page. It won't create the instance of
Excel. It blows up on the CreateObject class.
What am I missing?
Code, Error and Stack info are as follows:
Code:
Dim xlApp As Microsoft.Offic e.Interop.Excel .Application
xlApp = CreateObject("E xcel.Applicatio n") '**** Blows-up here *****
Error Exception Details:
System.Exceptio n: Cannot create ActiveX component.
Stack Trace:
[Exception: Cannot create ActiveX component.]
Microsoft.Visua lBasic.Interact ion.CreateObjec t(String ProgId, String
ServerName)
ReserveDB.WebFo rm1.btCreateDB_ Click(Object sender, EventArgs e) in
c:\inetpub\wwwr oot\ReserveDB\W ebForm1.aspx.vb :40
System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e)
System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP ostBackEvent(St ring eventArgument)
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
sourceControl, String eventArgument)
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData)
System.Web.UI.P age.ProcessRequ estMain()