Help with spreasheet control functions

[ltai0001]

Hi
I would like to use the microsoft OWC control on an access form. I
include the control in the form and rename as "ctrl_Sheet". I cant
access the control basic functions line "cells(), Activesheet,......"
etc .... when I call it from within the onLoad function of the form.
I even tried this

Private Sub Form_Load()
Dim sht As OWC11.Spreadsheet

Set sht = Me.Controls("ctrl_Sheet")

sht.Cells(1, 1) = 1
End Sub

I get a type mismatch error.


I really appreciate any help here

 

[Alvin Bruney [MVP]]

You have to use script to program the controls. It is a client-side object.

 

[ltai0001]

You have to use script to program the controls. It is a client-side object.

Hi
Thank you for your answer
After trying, I ended up using this:

Set sht = Me.Controls("ctrl_Sheet").object


That way I was able to access the methods in VBA.
Youssef