Coincidentally, I am also a Ruby Newbie, and just found out about
WIN32OLE. So far, the documentation I've found is very spare. One
trick I did learn in combing through the web was to use your system to
print out the methods available for the various applications:
# Win32OLE Variables
excel = WIN32OLE.new('Excel.Application')
word = WIN32OLE.new('Word.Application')
This gave me at least a start. You might also want to look at the help
file that is available on Office Automation at
If anyone else has any information on Office Automation, and
specifically how it fits into Win32OLE, I'd really appreciate it - what
I'd really like to have is a "canonical" list of all methods for each
available Office module. But I haven't found anything close to that
Chris Finch wrote:
I'm a newbie - please have patience.
I am not sure if anyone uses Ruby as an automation tool - I think it
would be a cool thing to do.
I have heard of the WIN32OLE extension - it sounds cool - does anyone
use this and why?
I was wondering if this automation only applies to these Windows
applications or is there any more you can control with a Ruby program?
I use the graphing application Origin - could I use Ruby to automate,
i.e. put data in and plot graphs.
Thanks in advance,
Posted via http://www.ruby-forum.com/.