Excel Automation Question

Hi - I have been writing an Excel Automation client in VC++, and what I have so far is extremely slow. I think the biggest problem is that my program needs to look at all 6 Border objects & extract line style and line weight properties from all border objects of every cell in a Range. This takes several minutes on most Ranges. One MS article that I found mentions using arrays to pass large amounts of data, but the only examples that they give is for the Range::GetValue() function. Is there a way to extract data from any other objects (esp. Border objects or Borders collection)in an array? Any calls that I can remove from my program will speed it up. Do any other objects support this array capability?

Any tips would be extremely helpful.

Thanks,
Jon Rizzo
Langan Engineering and Environmental Services, Inc.
[848 byte] By [jrizzo] at [2007-11-17 0:47:19]