SpreadSheet Control VBa

[Paul Richardson]

Can anyone point me to a good spreadsheet control.
OWC(office web components) spreadsheet v9 has
consumed my last nerve. Doesn't even need any
math functions. Just a decent working API.

Thank You,
Paul

[Paul Richardson]

Guess I should have stated my problem
with the Microsoft control.

Dim oRange as OWC.Range
Set oRange = Spreadsheet1.Cells(row#,column#)

I have never had a problem with this line in VB
always returning a Range, with vba sometimes
I get the Range and sometimes I get the value
in the cell instead. Anyone know why?

Thank You,
Paul

Post by Paul Richardson
Can anyone point me to a good spreadsheet control.
OWC(office web components) spreadsheet v9 has
consumed my last nerve. Doesn't even need any
math functions. Just a decent working API.
Thank You,
Paul

[Terry W. Dotson]

Post by Paul Richardson
Can anyone point me to a good spreadsheet control.

I like the FlexGrid from http://www.componentone.com or FarPoints
http://www.fpoint.com.

Terry

[Paul Richardson]

Thanks Terry..I almost went with fpoint
but figured I would wait a bit for responses.
I like componentone's price better...;-)

Post by Terry W. Dotson

Post by Paul Richardson
Can anyone point me to a good spreadsheet control.

I like the FlexGrid from http://www.componentone.com or FarPoints
http://www.fpoint.com.
Terry

[Terry W. Dotson]

Post by Paul Richardson
I like componentone's price better...;-)

Once thing I just thought of! FlexGrid is not guaranteed to work in
VBA, only VB. I have successfully used it for years but there can be
some errors on mouse level events!

Either way, try the demo before you buy.

Terry