C
Cameron
I have several forms with embedded OLE excel spreadsheets and when the user
selects a specific date range a query builds the table which in turn also
opens the form for the particular pivot table the user would like to see.
This calls the OLE object but doesn't force the object to update the query
and pull new data. How do I write the calling code in order to get the object
to automatically refresh the data?
The code calling the OLE object is as follows:
Private Sub btnEdit_Click()
On Error GoTo btnEdit_Err
Me!PivotTable.Verb = acOLEVerbOpen
Me!PivotTable.Action = acOLEActivate
btnEdit_Exit:
Exit Sub
btnEdit_Err:
MsgBox Error$
Resume btnEdit_Exit
End Sub
Private Sub Form_Load()
Call btnEdit_Click
End Sub
selects a specific date range a query builds the table which in turn also
opens the form for the particular pivot table the user would like to see.
This calls the OLE object but doesn't force the object to update the query
and pull new data. How do I write the calling code in order to get the object
to automatically refresh the data?
The code calling the OLE object is as follows:
Private Sub btnEdit_Click()
On Error GoTo btnEdit_Err
Me!PivotTable.Verb = acOLEVerbOpen
Me!PivotTable.Action = acOLEActivate
btnEdit_Exit:
Exit Sub
btnEdit_Err:
MsgBox Error$
Resume btnEdit_Exit
End Sub
Private Sub Form_Load()
Call btnEdit_Click
End Sub