I have a form with a OLE excel file embedded. The user can double click and populate the excel file. Upon closing, I would like to record that information into a table.
I have gotten to the point of trying to go through the locals window dissecting the structure. I have been unsuccessful thus far.
Code:
Private Sub Command8_Click()
Dim ctl As Control
Set ctl = Me!xlCashFlow
With ctl
' Enable control.
.Enabled = True
' Set Locked property to False.
.Locked = False
' Set Verb property to activate for editing.
.Verb = acOLEVerbShow
' Activate object.
.Action = acOLEActivate
End With
'recording the data should occur when the user closes the form, but just trying to get to the point where i can use .select.
ctl.Object.Application("a1").cells.offset(1, 1).select
End Sub
Any help you can provide will be appreciated.
Thanks!
Chris