[ruby-talk:13433] Re: [Q] Win32OLE documentation and tips??

At 10:10 31.03.01 +0900, Leo Razoumov wrote:
>I tried out a very nice and useful example from the Thomas & Hunt book
page 168.
>I am using Ruby-1.6.2 on Windows-2000 Professional and everything worked out
>just fine!!
>
>This script automatically starts Excel spreadsheet, enters data into the
cells,
>plots the data in the charts and even provides some animation.
>Automatic data entry and plotting is _very_ useful and can be a life saver.
>
>The only problem I have that the BOOK coverage of win32ole is very sketchy
and
>does not provide any hints on more advanced usage. I tried Visual Basic
Editor
>included with Excel. It lists some properties (with their names) of few OLE
>objects but I could not find out the particular attributes I need.

Hmmm...perhaps you have opened the general Visual Basic help, but not the
special help for VBA for Excel? This works for WinNT 4.0 SP6/ Office97 SP1
(I use a german version, so please apologize if I have made translation errors
 and the menu names are not exactly as they appear):

1) Start Excel.
2) Open the Visaul Basic Editor (Extras / Macro / Visual Basic Editor)
3) Open the help (?/ Contents/Index)
4) choose the tab "contents", then double click on
   "Visual Basic Reference for Microsoft Excel".
5) Double click on
   "Shortcut to Visual Basic Reference for Microsoft Excel"

There you are. I have toyed around a bit with irb and all that you want
seems to be possible. Unfortunately I do not have the time to explore this
further today.

Hope that helps. If not, feel free to ask.


-
Tammo Freese
[e-mail]