[thelist] [ASP] Excel COM object reference
Burhan Khalid
burhankhalid at members.evolt.org
Thu Nov 7 08:39:01 CST 2002
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 |
*-----------------------------------------------*
More information about the thelist
mailing list