Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003: instances not closing
I have several VB6.0 programs that open Excel, writes data in cells, closes
Excel several times within a program. This worked beautiful with Office 2000 without a hitch. My company recently pushed Office 2003 onto our machines, and the same programs no longer closes Excel. There is an instance for each time it opened Excel remaining in the background. This presents a problem for large number of instances. Does anyone know about this change in Excel? I've tested it on several machines with/without the new 2003 version. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003: instances not closing
"Aimster" wrote in message ... I have several VB6.0 programs that open Excel, writes data in cells, closes Excel several times within a program. This worked beautiful with Office 2000 without a hitch. My company recently pushed Office 2003 onto our machines, and the same programs no longer closes Excel. There is an instance for each time it opened Excel remaining in the background. This presents a problem for large number of instances. Does anyone know about this change in Excel? I've tested it on several machines with/without the new 2003 version. Use Application.Quit /Fredrik |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003: instances not closing
Is that any different from xlapp.quit which used to work for Excel 2000?
"Fredrik Wahlgren" wrote: "Aimster" wrote in message ... I have several VB6.0 programs that open Excel, writes data in cells, closes Excel several times within a program. This worked beautiful with Office 2000 without a hitch. My company recently pushed Office 2003 onto our machines, and the same programs no longer closes Excel. There is an instance for each time it opened Excel remaining in the background. This presents a problem for large number of instances. Does anyone know about this change in Excel? I've tested it on several machines with/without the new 2003 version. Use Application.Quit /Fredrik |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003: instances not closing
No, there is not difference
if xlapp is a reference to the excel application object. -- Regards, Tom Ogilvy "Aimster" wrote in message ... Is that any different from xlapp.quit which used to work for Excel 2000? "Fredrik Wahlgren" wrote: "Aimster" wrote in message ... I have several VB6.0 programs that open Excel, writes data in cells, closes Excel several times within a program. This worked beautiful with Office 2000 without a hitch. My company recently pushed Office 2003 onto our machines, and the same programs no longer closes Excel. There is an instance for each time it opened Excel remaining in the background. This presents a problem for large number of instances. Does anyone know about this change in Excel? I've tested it on several machines with/without the new 2003 version. Use Application.Quit /Fredrik |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003: instances not closing
If there's no different from xlapp.quit, then Application.Quit doesn't work
either. And, Tushar, no one makes changes but me, and I haven't made any since the move to Office 2003. I did notice that alot of the DLLs have been updated. I'm about ready to go back to Office 2000, if the company will let me. "Tushar Mehta" wrote: Shouldn't happen just because of a transition to 2003. Did anyone make *any* change to the VB6 program? One common cause of why XL doesn't close is at Program won't quit http://www.tushar-mehta.com/excel/vb...quit/index.htm -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I have several VB6.0 programs that open Excel, writes data in cells, closes Excel several times within a program. This worked beautiful with Office 2000 without a hitch. My company recently pushed Office 2003 onto our machines, and the same programs no longer closes Excel. There is an instance for each time it opened Excel remaining in the background. This presents a problem for large number of instances. Does anyone know about this change in Excel? I've tested it on several machines with/without the new 2003 version. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003: instances not closing
Aimster,
If you have the VB6 source, check if your variable "xlapp" is still valid just prior to the VB6 app's close. Otherwise there's this, although it says it applies to Excel 2002. It was last reviewed on February 19, 2005, so it may have a new fix. http://support.microsoft.com/kb/836031 Look towards the bottom for "Excel file is opened by using OLE and then closed but Excel process does not quit". NickHK "Aimster" wrote in message ... If there's no different from xlapp.quit, then Application.Quit doesn't work either. And, Tushar, no one makes changes but me, and I haven't made any since the move to Office 2003. I did notice that alot of the DLLs have been updated. I'm about ready to go back to Office 2000, if the company will let me. "Tushar Mehta" wrote: Shouldn't happen just because of a transition to 2003. Did anyone make *any* change to the VB6 program? One common cause of why XL doesn't close is at Program won't quit http://www.tushar-mehta.com/excel/vb...quit/index.htm -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I have several VB6.0 programs that open Excel, writes data in cells, closes Excel several times within a program. This worked beautiful with Office 2000 without a hitch. My company recently pushed Office 2003 onto our machines, and the same programs no longer closes Excel. There is an instance for each time it opened Excel remaining in the background. This presents a problem for large number of instances. Does anyone know about this change in Excel? I've tested it on several machines with/without the new 2003 version. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 restarts after closing | Excel Discussion (Misc queries) | |||
Unexpected Closing Excel 2003 | Excel Discussion (Misc queries) | |||
multiple Excel 2003 instances | Setting up and Configuration of Excel | |||
Prevent Excel closing all workbook instances when clicking on "X" | Excel Discussion (Misc queries) | |||
Excel 2003 / IE 6 bug closing workbook | Excel Programming |