ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   The object invoked has disconnected from its client (https://www.excelbanter.com/excel-programming/438190-object-invoked-has-disconnected-its-client.html)

Oldjay

The object invoked has disconnected from its client
 
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


All times are GMT +1. The time now is 08:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com