--- In [email protected], "Sheri" <sheri...@...> wrote: > > > --- In [email protected], "Sheri" <sherip99@> wrote: > > > > > If you still want to see some Properties that take a Double, look > > > at Excel.Application. Its Application class has quite a few such > > > properties, e.g., Top, Left, Width, StandardFontSize, and others.
comPlugin0.72_091210.zip in http://tech.groups.yahoo.com/group/power-pro/files/0_TEMP_/AlansPluginProvisional/ Don;t think I've made any relevant changes over comPlugin0.72_091209.zip, but just in case... > Using comPlugin0.72_091209 a property double can be set to nn.n without it > being inside quotes. However it still cannot be properly retrieved AFAICT. I tried this: objApp = com.create_object("Excel.Application") objApp.visible = 1 win.debug(objApp.width) objApp.width = 730 win.debug(objApp.width) objApp.width = 630 win.debug(objApp.width) Got flaky results, in sense that width didn't seem to set to the exact value specified with objApp.width = xxx. OTOH doubles seem to both go in and come out okay. Not entirely sure what it means to set a width to a fraction of a pixel, so maybe windows api doens;t either. Debugger seems to show doulbes going in and coming out. > Perhaps you should be reverse converting a property retrieved as a Double and > putting it into one of those r\x06 handles so that ftos will work for it. No, not necessary; everything comes back with a definite type set in VARIANT, I use VariantChangeType to change to a BSTR, then convert wrime wide string to ansi. I suspect there are also other formats besides Double to consider, e.g., Single and Currency. VariantChangeType should do the job. And for doubles seems to be doing so.
