Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.vb.general.discussion,microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I have this routine to disconnect from Excel: Public Sub XLDisconnectFromExcel() If Not moExcelWS Is Nothing Then Set moExcelWS = Nothing If Not moExcelApp Is Nothing Then Set moExcelApp = Nothing End Sub When the second line of that code is executed and moExcelApp is "Microsoft Excel" then that line of code is executed properly (Excel.exe is process terminated in Task Manager) but the code execution never returns after that line. It just dissapears and subsequently not any other code is executed. What can be wrong? To connect to Excel I use this code: Set moExcelApp = GetObject(, "Excel.Application") If moExcelApp Is Nothing Then Set moExcelApp = CreateObject("Excel.Application") End If Jack |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
automation code | Excel Discussion (Misc queries) | |||
keyboard shortcut hijacked? | Excel Programming | |||
Workshoot Menu Bar Hijacked!! | Excel Programming | |||
Code Librarian automation? | Excel Programming | |||
Automation Code Problem from Access to Excel | Excel Programming |