identify open workbook in excel?

[Bulhac Mihai]

-i have an excel file ex.xls open;
-can i make a script that will search all opened excel files and if an
excel file is ex.xls then ex.xls it will be memorized in an ruby
variable? how can i do that?

tbx

 

[David Mullet]

-i have an excel file ex.xls open;
-can i make a script that will search all opened excel files and if an
excel file is ex.xls then ex.xls it will be memorized in an ruby
variable? how can i do that?

tbx

require 'win32ole'

# Connect to a running instance of Excel:
excel = WIN32OLE.connect('Excel.Application')

# Select your workbook by name from the Workbooks collection:
my_workbook = excel.Workbooks('ex.xls')

Further discussion here:
http://rubyonwindows.blogspot.com/search/label/excel

David

http://rubyonwindows.blogspot.com