Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
The object invoked has disconnected from its clients
Error -2147417848 (&H80010108): The object invoked has disconnected from its
clients. when I run this macro the second time Option Explicit Private Sub CommandButton4_Click() 'Recall 0Master7 Application.ScreenUpdating = False Application.DisplayAlerts = False Workbooks.Open Filename:="C:\Quotes\0Master7.xls" Range("A1:H267").Select Selection.Copy Windows("Master7.xlsm").Activate Fail at this line I added the Option Explicit per MS info but it didn't help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
The object invoked has disconnected from its clients
Looks to me like you are opening a .xls file and trying to activate it as a
..xlsm file. Probably won't work. "oldjay" wrote in message ... Error -2147417848 (&H80010108): The object invoked has disconnected from its clients. when I run this macro the second time Option Explicit Private Sub CommandButton4_Click() 'Recall 0Master7 Application.ScreenUpdating = False Application.DisplayAlerts = False Workbooks.Open Filename:="C:\Quotes\0Master7.xls" Range("A1:H267").Select Selection.Copy Windows("Master7.xlsm").Activate Fail at this line I added the Option Explicit per MS info but it didn't help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The object invoked has disconnected from its clients | Excel Programming | |||
The object invoked as disconnected from its clients. - To many she | Excel Programming | |||
object invoked is disconnected from its clients | Excel Programming | |||
Object invoked disconnected from its clients. | Excel Programming |