[thelist] [ASP] Excel COM object reference

[Burhan Khalid]

JC> I have the following line of ASP code that creates an excel spreadsheet and
JC> saves it to the harddrive.

JC> Dim objSpreadsheet
JC> Set objSpreadsheet = Server.CreateObject("OWC.Spreadsheet")
JC> objSpreadsheet.Cells(1,1).Value = "hoser"
JC> objSpreadsheet.ActiveSheet.Export("c:\inetpub\jacquesdev\hoser.xls")
JC> Set objSpreadsheet = Nothing

Might not be something, but try adding objSpreadSheet.Application.Quit
before you set it to nothing.

>From the CreateObject reference :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/html/vafctcreateobject.asp

[ trim ]


--
*---------------*
| Burhan Khalid |
*---------------*-------------------------------*
| Email : burhankhalid[at]members.evolt.org     |
| Web   : members.evolt.org/burhankhalid        |
| ICQ   : 6016166                               |
| AIM   : digitz0819                            |
| MSN   : burhankh[at]hotmail.com               |
| Yahoo : burhan_khalid                         |
*-----------------------------------------------*
| mushkil hai zabas kalaam mera ai dil          |
| sun sun ke ise suKhan_varaa.N-e-kaamil        |
| aasaan kahane kii karate hai.n faramaaish     |
| goim mushkil vagaranaa goim mushkil           |
|-----------------------------------------------|
| Too hard to grasp is my verse, O heart!       |
| Hearing it, the connoisseurs of art           |
| For a simpler style do ask                    |
| Difficult, if I write, difficult, if I do not |
*-----------------------------------------------*