--- In [email protected], "Sheri" <sheri...@...> 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. Thanks. comPlugin0.72_091209.zip in http://tech.groups.yahoo.com/group/power-pro/files/0_TEMP_/AlansPluginProvisional/ The problem is that 2.4 is stored, and returns as a handle to a real number beginning r\x06. In this version I catch any such handles, convert them to doubles, and send them into the COM conversion machine. > See if you can figure out how to set the StandardFontSize to 24.5. No com > exception errors when the property value is passed in quotes, but if you > retrieve it after setting it, it debugs as 2. IOW, "24" seems to work, but > "24.5" apparently does not. That can be all sorts of things. Use ftos("24.5") to see what comes out. Write a tiny VBA macro to set the StandardFontSize to 24.5, see if it sticks. Haven't found out whey things like Woorkbooks(1) doesn't invoke the default accessor method Item yet.
