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

E

Elena

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?
 

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

Unreadable text when viewing organization chart in Web version of Visio 365 0
Create a chart from a table in word thats dynamic 0
VSTO C# add in Outlook.Appointment error 0
Creating a Chart on form from selected data in query. 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Imbedded OLE or Imbedded (Excel) Chart in 2007 Report? 0
Bound Chart in Report Issues - Access 2007 4
Linking data in MS Word into Excel 5

Top