From: Victor 'Zverok' Shepelev <vshepelev@...>
Date: 2006-10-26T21:48:23+09:00
Subject: Re: Win32OLE. Opening an existing file.

Peter Bailey (pbailey@bna.com)
26/10/2006 15:44:12

> Hi,
> Can someone tell me how I can use Win32OLE to open an existing file? All 
> the doc I've seen just shows you how to start a new file, like this:
> 
> require 'Win32ole'
> excel = WIN32OLE.new("excel.application")

excel = WIN32OLE.new('excel.application')
book = excel.Workbooks.Open(path)

Typical answer for all similar questions: open Excel, start macro recording, do what you want, stop macro recording. Open recorded macro - it would be in VBA, but can be ported into Ruby w. WIN32OLE pretty straightforward.

V.