View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz[_2_] JLGWhiz[_2_] is offline
external usenet poster
 
Posts: 1,565
Default 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