From: Jethrow Tole <jethrow@...>
Date: 2009-12-11T15:45:34+09:00
Subject: Access Excel

First off, I'm relatively new to Ruby. What I'm trying to do is access a
specific Excel Workbook that is alreay open. I already know the
following:
- access running Excel - WIN32OLE.connect("Excel.Application")
- access unsaved Excel Workbook - WIN32OLE.connect("Book1")

What I'm having difficuly with is connecting to a specific Excel object
(ie - if you open Excel via the Start menu, it creates a new Excel
object). One way I've been able to do this in another language would be
to use the full workbook name for the moniker, rather than "Book1". This
doesn't seem to work with WIN32OLE.connect(moniker), however, that
wouldn't be my preferred method. (if someone could let me know wha the
moniker would be to connect to a running workbook that has already been
saved, I would appreciate it)

The method I use in another language is calling
"AccessibleOjbectFromWindow" for the "EXCEL7" ChildWindow. However, I
can't seem to get this to work, and I haven't been able to locate any
Ruby examples for this dll call. Could someone provide an example of
calling "AccessibleOjbectFromWindow" for an Excel "EXCEL7" ChildWindow?
-- 
Posted via http://www.ruby-forum.com/.