Change and refresh OLEObject showing Excel chart.

C

Chrisso

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
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change and update OLEObject on form. 0
Change and refresh OLEObject showing Excel chart on Access form. 0
How to read the contents of an OLEObject (dropdown list) in excel 0
Excel crashes and restarts when accessing newly created worksheet 2
ItemAdd and FolderAdd events problem with Public Folders 0
ActiveX ProgressBar - Scrolling Error disables color update 1
Refresh Excel Sheet with Access Data Frequently 0
Multiple combo boxes and event handler class 1

Top