Re: [Wtr-general] selecting cells in Excell using activecell

2006-01-10 Thread Pierre Garigue
, January 10, 2006 9:39 AM To: wtr-general@rubyforge.org Subject: Re: [Wtr-general] selecting cells in Excell using activecell From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris McMahon Sent: January 9, 2006 6:41 PM To: wtr-general@rubyforge.org Subject: Re: [Wtr-general

Re: [Wtr-general] selecting cells in Excell using activecell

2006-01-10 Thread Chris McMahon
> I wonder how many people would be thrown by my desire to build objects like > CellPointers, and calls like > > p = CellPointer.new() > p.goto("$A$5") Go for it. What causes me to pull my hair out are the inability to address a cell by column number in the Range function; and all of the goofy num

Re: [Wtr-general] selecting cells in Excell using activecell

2006-01-10 Thread Michael Bolton
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris McMahon Sent: January 9, 2006 6:41 PM To: wtr-general@rubyforge.org Subject: Re: [Wtr-general] selecting cells in Excell using activecell > One fine day, I'll write a really good Ruby-Excel interface. Don't hold

Re: [Wtr-general] selecting cells in Excell using activecell

2006-01-09 Thread Chris McMahon
> One fine day, I'll write a really good Ruby-Excel interface. Don't hold > your breath, though. :) > > ---Michael B. If you're serious, I know some people who might help. I know other people who'd use such an interface, too. Some encouragement: it's a classic example of a DSL, and we all know

Re: [Wtr-general] selecting cells in Excell using activecell

2006-01-07 Thread Michael Bolton
ill confuse me a little Malcolm Beaton -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cain, Mark Sent: 04 January 2006 18:05 To: wtr-general@rubyforge.org Subject: Re: [Wtr-general] selecting cells in Excell using activecell This you might find helpful http:

Re: [Wtr-general] selecting cells in Excell using activecell

2006-01-04 Thread Beaton, Malcolm
ailto:[EMAIL PROTECTED] On Behalf Of Cain, Mark Sent: 04 January 2006 18:05 To: wtr-general@rubyforge.org Subject: Re: [Wtr-general] selecting cells in Excell using activecell This you might find helpful http://rubygarden.org/ruby?ScriptingExcel Also, I was playing around with your script and this w

Re: [Wtr-general] selecting cells in Excell using activecell

2006-01-04 Thread Cain, Mark
Beaton, Malcolm Sent: Wednesday, January 04, 2006 9:15 AM To: wtr-general@rubyforge.org Subject: [Wtr-general] selecting cells in Excell using activecell Maybe a little out of scope for this group but I am trying to write and retrieve cell data from Excel iteratively with ruby using the activecell

[Wtr-general] selecting cells in Excell using activecell

2006-01-04 Thread Beaton, Malcolm
Maybe a little out of scope for this group but I am trying to write and retrieve cell data from Excel iteratively with ruby using the activecell property. Only problem is it does not seem to work. My script is basically require 'win32ole' application = WIN32OLE.new('Excel.Application') applicat