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:

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