--- In [email protected], "Sheri" <sheri...@...> wrote:
> > I'm using VariantChangeType to coerce a BSTR ("4.0" received from
> > Powerpro, converted to a BSTR), That should work. But it doesn't.
> > My code could be fault in many places, but unless I can step
> > through it, can't see where.
>
> Hopefully you meant to say "coerce a Double..."
No, changing (coercing) a string into a double.
> I don't if of any help but I see ByVal Doubles as arguments in Math functions
> (not properties) in VBA's VBE6.dll (VBA=Visual Basic for Applications -- on
> my XP System with Office 2003 it is located at C:\Program Files\Common
> Files\Microsoft Shared\VBA\VBA6\VBE6.DLL).
Thanks, but your discovery that 4.0 goes into Bruce'#s internal real-number
format solves problem.
> > > local h=appRef.Selection.Item(1)
> > > using comPlugin0.72_091207 yields
> >
> > > ERROR: com.method: Invoke failed (sys code 80020009: "Exception
> > > occurred.")
> >
> > Weird, that. There's an rquivalent problem in Excel script
> > comPluginDemoScriptExcelDotSyntax.powerpro:
> >
> > local objSheet = objApp.ActiveWorkbook.Worksheets(1)
> >
> > Will look into it, though I'm getting kinda stuck.
> >
>
> Similar problem but different error message for Excel script:
>
> local objSheet = objApp.ActiveWorkbook.Worksheets(1)
>
> using comPlugin0.72_091207 yields
>
> ERROR: com.method: Wrong number of parameters
Problem is my code is no longer causing the default accessor function for a
collection to be invoked. It used to.
That'll take a while to sort out.
