The Win32OLE extension library comes with Ruby 1.8.0 (or later). You can get Win32OLE extension library source if you download Ruby 1.8.0 source.
Win32OLE extension library provides an interface to OLE Automation from Ruby. Here is a sample script:
require 'win32ole' application = WIN32OLE.new('Excel.Application') application.visible = TRUE workbook = application.Workbooks.Add(); worksheet = workbook.Worksheets(1); worksheet.Range('A1:D1').value = ['North','South','East','West'];
As this sample, You can convert your VBA macro to Ruby script easily.
Win32OLE 0.5.2 (2005-03-19) md5sum:c3a8a8590350226d54b8c543a565b33b (56040byte)
Simple OLE Browser is like as OLE Viewer or Object Browser.
You need swin and vruby.
soleb 0.0.1a (2005-03-19) md5sum:1a4c8ba5de3f5a43c4d7ec37e26082fb (2069byte)