From: "thebusyant@..." <thebusyant@...>
Date: 2008-03-16T03:44:53+09:00
Subject: win32ole and autofilling

Does anyone know how to perform an autofill within an Excel workbook
via win32ole?

I've tried a couple of things that don't work and I'm now stumped.

e.g.
worksheet.Range("F2").AutoFill  #=> yields "parameter not optional",
so we're on the right track, but obviously need to tell the worksheet
*where* to autofill

worksheet.Range("F2").AutoFill("F3:F20") # gives Unable to get the
AutoFill property of the Range class

worksheet.Range("F2").AutoFill("Destination" => "F3:F20", "Type"=>0) #
gives Unable to get the AutoFill property of the Range class

worksheet.Range("F2").AutoFill("Destination" => 'Range("F3:F20")',
"Type" => 0) # gives Unable to get the AutoFill property of the Range
class

worksheet.Range("F2").AutoFill("Destination" => 'Range("F3:F20")',
"Type"=>"0") # gives Unable to get the AutoFill property of the Range
class

???

The VBA code for autofilling looks like this, but i'm not sure what
syntax I should use for win32ole
Range("F2").Select
    Selection.AutoFill Destination:=Range("F3:F20"),
Type:=xlFillDefault

TIA