Windows 7 64bit win32ole connect method Excel

Ruby
1

Does anyone know possible reasons for the WIN32OLE.connect would not
connect to an open instance of Excel 2007 on Windows 7 64bit? I have
both Rubyinstaller (1.9.3p392) and Railsinstaller (1.9.3p125) versions
of Ruby installed. Both versions have the same error:

WIN32OLERuntimeError: OLE server `Excel.Application’ not running
HRESULT error code:0x800401e3

When trying WIN32OLE.new with an already opened Excel instance, Ruby
will open up a new instance.

I am looking for advice on any resources that could be looked in, a
direct answer or methods for debugging.

Thanks,
Timothy

2

Works fine for me in the same system, same Ruby version, I have no Rails
version installed.

excel = WIN32OLE.new(‘Excel.Application’)
excel = WIN32OLE.connect(‘Excel.Application’)

So you have Microsoft Office installed…

3

Damian,

It has worked for me for many months/years prior. I just installed new
versions of Ruby and updated some unrelated gems and now I am having
this problem. I’m hoping someone with windows experience can give me a
clue as to how an instance of excel is running but it is not registered
with the ole server.

Timothy

4

Well you can try downgrading one by one the gems related, to see if any
dependency is breaking something. That’s all the help I can give you.