More »

Ruby & PowerPoint: Inserting HyperLinks

almost 2 years ago by David Mullet on Ruby on Windows.
I've written previously about automating Microsoft PowerPoint with Ruby. Someone recently asked how to use Ruby code to insert hyperlinks into a PowerPoint...

Saving Microsoft Office Documents as PDFs

~2 years ago by David Mullet on Ruby on Windows.
A recent discussion in the Ruby Forum reminded me that it is possible with Microsoft Office 2007 applications to save a document in Adobe PDF format.In...

Connecting to One of Many Open Documents

~2 years ago by David Mullet on Ruby on Windows.
If you've hung around here for a little while, then you probably already know that you can use the WIN32OLE.connect() method to connect to a running instance...

Creating an iTunes Song Inventory in Excel

~2 years ago by David Mullet on Ruby on Windows.
I've talked in the past about automating iTunes, and about automating Excel. Let's now look at how to use Ruby to produce an iTunes report in Excel. Our...

Ruby & Word: Inserting Pictures Into Documents

over 2 years ago by David Mullet on Ruby on Windows.
In an earlier article, I explained how to insert an image into a range of cells in an Excel worksheet. Today we'll look at how to insert an image into a...

About the Book

over 2 years ago by David Mullet on Ruby on Windows.
A few readers have asked me for details on the book-in-progress.The working title is "Automating Windows Applications with Ruby". As the title implies,...

Ruby & Excel: Inserting Pictures Into Cells

over 2 years ago by David Mullet on Ruby on Windows.
A reader recently asked how to insert an image from their PC into a cell in an Excel worksheet. So if you have a couple of minutes, I'll demonstrate how...

Ruby & Excel: Inserting Pictures Into Cells (New and Improved!)

over 2 years ago by David Mullet on Ruby on Windows.
In a previous article, I discussed a method for inserting images into an Excel worksheet. It seems that the Worksheet.Pictures.Insert() method that I demonstrated...

OCR: Converting Images to Text with MODI

over 2 years ago by David Mullet on Ruby on Windows.
Joe Schmoe from Kokomo has a scanned image of a 300-page contract. Joe wishes he could search this file for certain rates and terms, but it's an image...

Ruby & Excel: Hiding and Unhiding Columns, Rows, and Worksheets

over 2 years ago by David Mullet on Ruby on Windows.
Occasionally, when working with Excel, you may have a need to hide certain columns or rows in a worksheet. As an example, perhaps your worksheet lists revenue...