OWC Spreadsheet in access 2003

[c19h28o2]

Hi,

I've added an OWC 11 component to an Access Form but cannot access the
cells via vba

I have tried setting the object as follows

Dim owcSpread As OWC11.Spreadsheet

Set owcSpread = Form_Form1.Spreadsheet0

But I get a type mismatch.....

I have also just tried Form_Form1.Spreadsheet0 but intellisense
doesn't display anything about cells etc.

Thanks for any help...

 

[Alvin Bruney [ASP.NET MVP]]

You need to call get_OCX() (i think that's the name of the method), that
returns the activex object from the form.

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99