[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

identify open workbook in excel?

Bu Mihai

11/12/2007 10:00:00 AM

-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
--
Posted via http://www.ruby-....
1 Answer

David Mullet

11/12/2007 10:38:00 PM

0

Bulhac Mihai wrote:
> -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.bl.../search/l...

David

http://rubyonwindows.bl...
--
Posted via http://www.ruby-....