View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bernie Yaeger Bernie Yaeger is offline
external usenet poster
 
Posts: 8
Default closing an excel worksheet inside vb .net

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