C
Chrisso
(Sorry this is not strictly Excel charting but I have had no hints in
the Access groups where I posted this first - hoping someone in the
Excel world can help me)
Hi All
I display an Excel chart in a MS Acess User form using an unbound OLE
object. I am trying to change the Excel workbook(and therefore chart)
that my OLEObject 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
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,
Chrisso
the Access groups where I posted this first - hoping someone in the
Excel world can help me)
Hi All
I display an Excel chart in a MS Acess User form using an unbound OLE
object. I am trying to change the Excel workbook(and therefore chart)
that my OLEObject 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
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,
Chrisso