Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I wrote a program in vb.net 2005 to open a spread sheet, read data and then
close the spreadsheet. The probelm is it is not really closing. Dim xlApp As Excel.Application Dim xlBook As Excel.Workbook Dim xlSheet As Excel.Worksheet ' OPEN WORKSHEET AND DO STUFF xlBook.Application.Visible = True xlBook.Windows(1).Visible = True xlBook.Application.WindowState = Excel.XlWindowState.xlMinimized ' Call loadSheet(xlbook.Worksheets(SheetName)) xlBook.Close(True) xlApp.Quit() NAR(xlBook) NAR(xlApp) Private Sub NAR(ByVal o As Object) Try System.Runtime.InteropServices.Marshal.ReleaseComO bject(o) Catch ex As Exception Finally o = Nothing End Try End Sub Can someone tell me what I am doing wrong? -- Arnie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple Excel Spread Sheets | Excel Discussion (Misc queries) | |||
cant open SAVED excel spread sheets | Excel Discussion (Misc queries) | |||
how do i look up and create excel spread sheets | Excel Worksheet Functions | |||
Updating 2 excel spread sheets? | Excel Discussion (Misc queries) | |||
how do I get a download for excel spread sheets only | Excel Discussion (Misc queries) |