--- In [email protected], "entropyreduction" <alancampbelllists+ya...@...> wrote: > > --- In [email protected], "Sheri" <sherip99@> wrote: > > > > > appRef.ScriptPreferences.Version = 4.0 > > > > using comPlugin0.72_091207 yields > > > ERROR: com.set_property: Optional variable type problem (sys code > > 80020005: "Type mismatch.") > > I can't really debug this sort of thing unless I can execute the code. > > If you can find some object that has a set property that takes a > double, one that I can execute, let me now. I've been through > word app object, some FSO objects, so far found nothing useful. > > 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..." 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). If you'd care to print some debug text to an output file during processing, I'd be glad to upload the result. Bruce was able to use that technique to successfully debug-by-proxy some special processing for 64-bit Windows. > > > 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 Regards, Sheri
