Re: Excel problem

["Norm Dennis" <nhdennis@xxxxxxxxxxx>]

Jon,
Have you resolved this now?

Cheers,


Norm Dennis

-----Original Message-----
From: pctech-bounces@xxxxxxxxxxxx [mailto:pctech-bounces@xxxxxxxxxxxx] On
Behalf Of Jon Paris
Sent: Sunday, 28 June 2009 3:34 AM
To: pctech@xxxxxxxxxxxx
Subject: Re: [PCTECH] Excel problem


On 27-Jun-09, at 1:00 PM, pctech-request@xxxxxxxxxxxx wrote:

> Are you using VBA in Excel? Almost have to be. Anyhow, there is a  
> Cells
> collection, I think, for various entities - including a Range - the
> Cells collection is essentially a 2-dimension array, so you use  
> numeric
> row and column Cells(2,3) is the cell in row 2, column C.

That's what I've been forced to do Vern.  I was hoping there was a way  
to avoid it as I've never used it before and had no desire to learn. I  
haven't used the range notion (had trouble finding simple examples)  
but was able to iterate through the sheet simply with a For loop and  
direct cell references.

One thing made me laugh out loud though - everything else that works  
with Excel that I have seen (like the POI classes) has Column A as 0,  
B as 1 and so on. In VBA A is 1, B is 2, etc.  That caused me a small  
debugging delay!

Thanks for the advice.



Jon Paris

www.Partner400.com
www.SystemiDeveloper.com