--- In [email protected], "entropyreduction"
<alancampbelllists+ya...@...> wrote:
Play with Excel.Application's GetSaveAsFileName. All the arguments are
Variants. The method's objective is to show the file-save dialog and return a
file name (or zero if canceled), not to do an actual file save.
I'm still running with comPlugin0.72_091218_no_guesses
This works:
local saf=appRef.method_typed("GetSaveAsFileName", "s s u s ", ;;+
"TestVariants.xls", "Excel Files (*.xls),*.xls", 1, "Hello")
Even using method_typed, there is currently no type setting available that
would allow you to skip an optional argument.
Would like to come up with some procedure that would allow typing of Variant
arguments for use in normal method instead of method_typed.
How about:
com.setargtypes="s s u s "
ExcelApp.GetSaveAsFileName("TestVariants.xls", "Excel Files (*.xls),*.xls", 1,
"Hello")
com.clearargtypes
Would also want com.getargtypes
(but still need a way to spec optional argument to be skipped, e.g., how to
skip the two arguments before "Hello"?)
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)
This:
ExcelApp.GetSaveAsFileName("TestVariants.xls")
currently shows the save-as dialog but shows double quotes around the proposed
file name.
Regards,
Sheri
