modify data source of an oleunbound (excel chart) in access report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have included in my access report a chart created in excel

I need to update the source data of this char on the On Open Event of the
Report

OLEUnbound39.Sheets(1).Range("B1")Value=.... brings the error " Object
does not support this property"

Yet, this error appears only if I use this code on thr On Open Event of the
Report, whereas if refer to the report and its oleunbound object from a form
for example the code works alright

Any suggestions?
 
Back
Top