
CreateObject("Excel.Application") problem
Hi all,
I got a problem with scripting Excel application in asp.
I have use the below code to open an excel file
Dim xlApp, xlBook, xlSheet1
Set xlApp = CreateObject("Excel.Application")
Set xlBook = xlApp.Workbooks.Add
Set xlSheet1 = xlBook.Worksheets(1)
xlSheet1.cells(1,1).value = "11"
xlSheet1.cells(2,1).value = "11"
xlSheet1.cells(2,2).value = "11"
xlSheet1.cells(2,3).value = "11"
xlSheet1.cells(2,4).value = "11"
xlBook.SaveAs "c:\monthly.xls"
xlApp.Quit
Set xlApp = Nothing
I run it in IIS of three different OSs and got different
results. Can anyone advise me what is happening?
1. OS - Windows NT 4.0 SP 6
The file successfully created without any problem
2. OS - Windows 2000 Professional SP3
There is an internal server error 500
3. OS - Windows 2000 Server SP2
The file successfully created together with a shortcut
Thanks a lot
Wahodi