Prev: Excel libraries in VB.NET
Next: Comments and Print Preview
From: oldjay on 9 Jan 2010 14:19
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
From: JLGWhiz on 9 Jan 2010 16:26
Looks to me like you are opening a .xls file and trying to activate it as a
..xlsm file. Probably won't work.


"oldjay" <oldjay(a)discussions.microsoft.com> wrote in message
news:D706B125-B92D-4C2A-8321-AF628D80BC03(a)microsoft.com...
> 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


 | 
Pages: 1
Prev: Excel libraries in VB.NET
Next: Comments and Print Preview