From: Bev Jennings <bhjdownload@...>
Date: 2010-11-06T00:20:51+09:00
Subject: Re: Excel and Ruby

hi DanSr

Your suggested format works like a charm (thanks so much) so I am now 
back in business and have succesfully extracted the info I needed from 
the 9 cells in row 3.  Now the next trick we need to apply our minds to 
is how via a loop we can change the row number in the Range parameter in 
the worksheet.Range('b3').value statement (i.e. 3 in the example you 
sent to me) to say 6 or any other specified value. So that I can extract 
the same 9 cells in row 6 that I did in row 3 and so on looping down to 
cover the rows that I need.  In other words do you think that we can use 
a varible like rowno in worksheet.Range('b+rowno').value instead of 3 or 
6.

-- 
Posted via http://www.ruby-forum.com/.