--- In [email protected], "Sheri" <sheri...@...> wrote: > > > Try comPlugin0.72_100111.zip in > > http://tech.groups.yahoo.com/group/power-pro/files/0_TEMP_/AlansPluginProvisional/ > > > > My intention with set_arg_types was that "t" would mark an absent > > parameter: so like this: > > > > com.set_arg_types("s t t s ") > > objApp.GetSaveAsFileName("TestVariants.xls", "Hello") > > > > not this > > objApp.GetSaveAsFileName("TestVariants.xls", "", "", "Hello") > > That doesn't seem sensible, would prefer the content of any provided > arguments meant to be skipped just be discarded.
I think "omit" means omit, but I can probably get both variations to work. > > But anyway doesn't work yet. Among other things I should be > > picking up any default value available via FUNCDESC, or at least > > I think I should. > > I don't think that should be necessary. If the argument is left off from the > end the defaults are automatically applied and my understanding is that the > same thing should happen if the argument is properly skipped (with via a > special error variant). Okay, for now I'll comment out that bit of code ansd see what happens. > > Does comPlugin0.72_100111.zip take care of problems with your > > Search method? > > No. > > FYI: chgVec[0,1]=123 and chgVec[0,2]=abc > > r=myselect.Search(chgVec[i,1], wholeword, casesensitive, chgVec[i,2]) > -------------------------- > ANSI arguments, no set_arg_types: > > comPlugin0.72_100111 > ERRORS: com.method: Invoke failed (sys code 80020009: "Exception occurred.") Sigh, back to drawing board. I'll need to find something that does the same using some COM object I have access to. > Haven't tried anything yet with Excel errors or skipped arguments with > comPlugin0.72_100111. Note that the vbscript error message when there was no > Workbook open when ActiveWorksheet was referenced came directly from the > runtime, not from Excel.exe. Some internal mechanism may be trapping that no > Object was returned when one was expected. Understood. > You could also release .72 without enhanced error reporting, and work on that > in a later release if this doesn't gel quickly. Yeah, all I have to do is get 0.72 rto work right....
