I gave the link above, here it is again: Ruby Standard lib: Win32OLE class
This is the MS link I have bookmarked for use with OLE:
I had posted a basic example I think over at SketchUcation:
There are many old topic threads on SketchUp <-> Excel communication over there in the Developers forum.
I do not do workflow code for free anymore. And I do not have MS Office anymore to test with anyhow.
This other code example I posted a few weeks ago might interest you: