The object invoked has disconnected from its client

O

oldjay

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The object invoked has disconnected from its clients 1
The object invoked has disconnected from its clients 7
Error Message 3
Run-time error ‘-2147417848(8001 2
object disconnected from client error message 3
trouble fixing "object invoked has disconnected from its clients" error 2
Copying worksheets between workbooks - The object invoked hasdisconnected from its client 0
Run-time error: The object invoked has disconnected from its clients 2

Top