Hi All
I am trying to change the Excel workbook that my OLEObject on a form
displays:
Private Sub Form_Load()
With Me.oleExcelChart
' SourceDoc is currently "W:\Public\83.xls"
Debug.Print .SourceDoc
.SourceDoc = "W:\Public\XX.xls"
Debug.Print .SourceDoc
' ## how can I get the OLEobject to repaint/redisplay/change?!
End With
End Sub
[Quoted Text] >> When run this results in this output:
W:\Public\83.xls
W:\Public\XX.xls
However the OLEObject is stil displaying 83.xls! How can I complete
the step and tell the OLEobject to refresh/update to the new/different
Excel file?
Thanks in advance for any ideas,
Chris
|