[python-win32] [Fwd: Re: Excel advanced find]

[Dan Glassman]

Dan Glassman wrote:
> Named arguments will work as suggested; this will prevent those 
> arguments from being presented to the Excel interface at all.  You can 
> also use pythoncom.Missing, which is another way to prevent arguments 
> from being presented to the interface:
> 
> [code]
> from pythoncom import Missing
> usedRange = xlApp.ActiveSheet.UsedRange
> usedRange.Find('FXN3', Missing, constants.xlValues,
>                 constants.xlWhole, constants,xlByColumns,
>                 constants.xlNext, False, False, Missing)
> [/code]

Whoa -- disregard that suggestion; that was really bad idea on my
part.  All the arguments after the first Missing get ignored if you do that.

Named arguments, then.

-- 
-Dan Glassman