From: zak <u.gotzes@...>
Date: 2010-03-03T20:45:06+09:00
Subject: Re: win32ole excel "links to other workbooks"

Thank you very much! Unfortunately I'm not able to implement it.
I use this concept:

http://blade.nagaokaut.ac.jp/cgi-bin/scat.rb/ruby/ruby-talk/245780

and tried:

class ExcelConst
# to be filled with all Excelconstants
# once excel is running
end

class Excel
   attr_accessor :excel
   def initialize
      require 'win32ole'
      @excel = WIN32OLE::new('Excel.Application')
      WIN32OLE.const_load(@excel, ExcelConst)
      @excel.DisplayAlerts = false
      yield self
      @excel.Quit
   end

   def open_book file
      book =
self.excel.Workbooks.Open(file,UpdateLinks=ExcelConst::XlUpdateLinksNever)
      yield book
      self.excel.ActiveWorkbook.Close(0)
   end
end

Any ideas?