[power-pro] Re: com plugin 0.72_091217

[Sheri]

--- In power-pro@yahoogroups.com, "entropyreduction" 
<alancampbelllists+ya...@...> wrote:
> 
> --- In power-pro@yahoogroups.com, "Sheri" <sherip99@> wrote:
>
> > This:
> > ExcelApp.GetSaveAsFileName("TestVariants.xls")
> >
> > currently shows the save-as dialog but shows double quotes around
> > the proposed file name. 
>
> Odd.  Okay, will play when I get home
>
 
It seems that double quotes being shown around the proposed file name is 
standard behavior (even in VBA and vbscript) when the initial file filter is 
*.* If the optional file filter parameter is omitted, the initial file filter 
defaults to *.*.
 
> > Currently this gets a com exception error:
> > ExcelApp.GetSaveAsFileName("TestVariants.xls", "Excel Files
> > (*.xls),*.xls", 1, "Hello")
> >
> > I was planning to try having all digits in the last argument to
> > see if that generated an error similar to the one I've been
> > seeing, but no need (since it bombs even given unambiguous data)
 
com exception problem probably has something to do with the improper handling 
of input VARIANTs.
 
Regards,
Sheri