From: Siep Korteling <s.korteling@...>
Date: 2008-03-16T06:32:56+09:00
Subject: Re: win32ole and autofilling

thebusyant@gmail.com wrote:
> Does anyone know how to perform an autofill within an Excel workbook
> via win32ole?
> 
(...)
This more of a VBA question then a ruby problem.
On my excel 2003:


require 'win32ole'
xcel = WIN32OLE.new('excel.application')
xcel.visible = true
xcel.workbooks.add

xcel.range("A1:B1").value = 1

start1 = xcel.range("A1")
start2 = xcel.range("B1")
target1 = xcel.range("A1:A10")
target2 = xcel.range("B1:B10")

start1.autofill(target1)
start2.autofill(target2 , 2)
#this can also be done by putting 2 in B2 and
#setting  start2 to range(B1:B2)


Regards,

Siep
-- 
Posted via http://www.ruby-forum.com/.