Posted to microsoft.public.excel.programming
|
|
closing an excel worksheet inside vb .net
Hi Rob,
Thanks so much - not closing objwb was indeed my problem.
Tx again,
Bernie
"Rob Bovey" wrote in message
...
Hi Bernie,
A Worksheet object doesn't have a close method. It's the objwb
variable,
which represents an Excel.Workbook object, that you need to close. If the
objws variable is a local variable, you really don't need to do anything
at
all, but if you want to explicitly release it for garbage collection then
add the following line to your code:
objws = Nothing
--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/
* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
"Bernie Yaeger" wrote in message
...
I have the following code fragment for opening and the closing excel in
a
vb
.net app:
objxl = New Excel.Application
objwbs = objxl.Workbooks
objwb = objwbs.Add
objws = CType(objwb.Worksheets(1), Excel.Worksheet)
objwb.SaveAs(strpath, xlCSV)
objxl.DisplayAlerts = False
'objws.close()
objxl.DisplayAlerts = True
Marshal.ReleaseComObject(objws)
objxl.Quit()
My question is, how do you close opjws? The close method no longer
exists.
Tx for any help.
Bernie
|