ASP.NET, Excel Reports

[olivia919]

I am not sure what I am missing here.
The page is stuck when it is exexuting
xl = CreateObject("excel.application")
"web site found, waiting for reply....."
Please help! Thanks a lot....

Imports System
Imports System.Reflection
Imports System.Runtime.InteropServices
Imports Excel

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Put user code to initialize the page here
Dim xl As New Object()
Dim wb As Excel.Workbook
Dim sh As Excel.Worksheet
xl = CreateObject("excel.application")
'+++++++++++++++++++++++++++++++++++++++++++++++++++++
End Sub

 

[ca8msm]

Maybe it can't create a new excel object....

Also you shouldn't declare your xl variable as an object - it should be:

Dim xl as New Excel.Application

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[olivia919]

thanks for the reply. Dim xl as New Excel.Application is one of the methods. i tried that too. had the same kind of problem

 

[ca8msm]

There may be a permissions problem then...

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.