Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've got the following problem:
When I open an excel file from VB6, save it and close it again EXCEL does not remain in the taskbar, but when I make a copy of a sheet and save and close the file excel does remain? Anybody has an idea? This doesn't work: Dim XLObj as Public XLObj As Excel.Application Set XLObj = CreateObject("Excel.Application") XLObj.Workbooks.Open "c:\test_file.xls" XLObj.DisplayAlerts = False XLObj.ActiveWorkbook.Sheets("testsheet").Copy Befo=Sheets(1) XLObj.ActiveWorkbook.Save XLObj.ActiveWorkbook.Close XLObj.UserControl = False XLObj.DisplayAlerts = True XLObj.Quit Set XLObj = Nothing This works: Dim XLObj as Public XLObj As Excel.Application Set XLObj = CreateObject("Excel.Application") XLObj.Workbooks.Open "c:\test_file.xls" XLObj.DisplayAlerts = False XLObj.ActiveWorkbook.Save XLObj.ActiveWorkbook.Close XLObj.UserControl = False XLObj.DisplayAlerts = True XLObj.Quit Set XLObj = Nothing |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel close on startup, but stay in task manager | Excel Discussion (Misc queries) | |||
Excel still running in task manager after closing the application | Excel Discussion (Misc queries) | |||
Task Manager and Excel 2003 | Excel Discussion (Misc queries) | |||
get the program id of an excel application from the task manager | Excel Programming | |||
Excel Remains Active in Windows Task Manager | Excel Programming |