CAN ANYONE SOVLE THIS PROBLEM!!!
in [Programming]
|
Prev: Microsoft Office Excel is waiting for another application to complete an OLE action
Next: I want to use a oleDragDrop in an Excel VBA Userform
From: Jim Warren on 17 Mar 2005 13:31 HERE'S THE CODE: Dim NDXcode As String, StartLine As Long NDXcode = ActiveSheet.CodeName With ActiveWorkbook.VBProject.VBComponents(NDXcode).CodeModule StartLine = .CreateEventProc("SelectionChange", "Worksheet") .InsertLines StartLine, _ <TEXT IS INSERTED HERE> HERE'S THE ERROR: " the object invoked has disconnected from its client" and Excel crashes THE ERROR OCCURS AT .InsertLine StartLine,...BUT IT ALSO HAPPENS IF I SINGLE STEP TO THE PREVIOUS LINE AND TYPE IN THE IMMEDIATE WINDOW "Print StartLine"
From: Myrna Larson on 17 Mar 2005 14:46 What happens if you turn off Event trapping before you try to insert the procedure? On Thu, 17 Mar 2005 10:31:04 -0800, "Jim Warren" <JimWarren(a)discussions.microsoft.com> wrote: >HERE'S THE CODE: >Dim NDXcode As String, StartLine As Long >NDXcode = ActiveSheet.CodeName >With ActiveWorkbook.VBProject.VBComponents(NDXcode).CodeModule > StartLine = .CreateEventProc("SelectionChange", "Worksheet") > .InsertLines StartLine, _ > <TEXT IS INSERTED HERE> >HERE'S THE ERROR: >" the object invoked has disconnected from its client" and Excel crashes >THE ERROR OCCURS AT .InsertLine StartLine,...BUT IT ALSO HAPPENS IF I SINGLE >STEP TO THE PREVIOUS LINE AND TYPE IN THE IMMEDIATE WINDOW "Print StartLine"
From: Jim Warren on 17 Mar 2005 14:59 I haven't tried that. But I will and let you know. "Myrna Larson" wrote: > What happens if you turn off Event trapping before you try to insert the > procedure? > > > On Thu, 17 Mar 2005 10:31:04 -0800, "Jim Warren" > <JimWarren(a)discussions.microsoft.com> wrote: > > >HERE'S THE CODE: > >Dim NDXcode As String, StartLine As Long > >NDXcode = ActiveSheet.CodeName > >With ActiveWorkbook.VBProject.VBComponents(NDXcode).CodeModule > > StartLine = .CreateEventProc("SelectionChange", "Worksheet") > > .InsertLines StartLine, _ > > <TEXT IS INSERTED HERE> > >HERE'S THE ERROR: > >" the object invoked has disconnected from its client" and Excel crashes > >THE ERROR OCCURS AT .InsertLine StartLine,...BUT IT ALSO HAPPENS IF I SINGLE > >STEP TO THE PREVIOUS LINE AND TYPE IN THE IMMEDIATE WINDOW "Print StartLine" > >
From: Jim Warren on 17 Mar 2005 15:21 How do you turn off Event trapping? "Jim Warren" wrote: > I haven't tried that. But I will and let you know. > > "Myrna Larson" wrote: > > > What happens if you turn off Event trapping before you try to insert the > > procedure? > > > > > > On Thu, 17 Mar 2005 10:31:04 -0800, "Jim Warren" > > <JimWarren(a)discussions.microsoft.com> wrote: > > > > >HERE'S THE CODE: > > >Dim NDXcode As String, StartLine As Long > > >NDXcode = ActiveSheet.CodeName > > >With ActiveWorkbook.VBProject.VBComponents(NDXcode).CodeModule > > > StartLine = .CreateEventProc("SelectionChange", "Worksheet") > > > .InsertLines StartLine, _ > > > <TEXT IS INSERTED HERE> > > >HERE'S THE ERROR: > > >" the object invoked has disconnected from its client" and Excel crashes > > >THE ERROR OCCURS AT .InsertLine StartLine,...BUT IT ALSO HAPPENS IF I SINGLE > > >STEP TO THE PREVIOUS LINE AND TYPE IN THE IMMEDIATE WINDOW "Print StartLine" > > > >
From: Tom Ogilvy on 17 Mar 2005 16:51
I think she mean's Application.EnableEvents = False -- Regards, Tom Ogilvy "Jim Warren" <JimWarren(a)discussions.microsoft.com> wrote in message news:980CB7B2-9D31-49C5-94EF-F7CA1E042EAA(a)microsoft.com... > How do you turn off Event trapping? > > > "Jim Warren" wrote: > > > I haven't tried that. But I will and let you know. > > > > "Myrna Larson" wrote: > > > > > What happens if you turn off Event trapping before you try to insert the > > > procedure? > > > > > > > > > On Thu, 17 Mar 2005 10:31:04 -0800, "Jim Warren" > > > <JimWarren(a)discussions.microsoft.com> wrote: > > > > > > >HERE'S THE CODE: > > > >Dim NDXcode As String, StartLine As Long > > > >NDXcode = ActiveSheet.CodeName > > > >With ActiveWorkbook.VBProject.VBComponents(NDXcode).CodeModule > > > > StartLine = .CreateEventProc("SelectionChange", "Worksheet") > > > > .InsertLines StartLine, _ > > > > <TEXT IS INSERTED HERE> > > > >HERE'S THE ERROR: > > > >" the object invoked has disconnected from its client" and Excel crashes > > > >THE ERROR OCCURS AT .InsertLine StartLine,...BUT IT ALSO HAPPENS IF I SINGLE > > > >STEP TO THE PREVIOUS LINE AND TYPE IN THE IMMEDIATE WINDOW "Print StartLine" > > > > > > |