--- In [email protected], "Sheri" <sheri...@...> wrote: > > In your comPluginDemoExcelSheri I commented out: > > if (appRef.Workbooks.Count < 1) > appRef.Workbooks.Add > > and added > > local mysheet=appRef.ActiveSheet > > Got ERRORS: com.method: Invoke failed Object can't be found > > How ever you're doing it, it is nice that Powerpro no longer crashes > :)
Makes a change. > With the compound statement > appRef.ActiveSheet.Name = "TestSheet" > > same error, but if I click Cancel, Powerpro doesn't immediately quit but > continues with one more error: > > Expression before = does not yield valid handle for use with . That's from Bruce, not me...dunno why PP doesn;t come to a halt with the first error. > Probably normal when in its in the midst of a dot sequence. ...and is correct. appRef.ActiveSheet doesn;t evaluate to an object, so following dot makes no sense to parser.
