Update embeded chart in Report

[jer99]

I have a report called :Audit_Report_Page_14 that has a chart on it. This chart is linked to a Oracle table via ODBC.

Manually this is what I have to do:
1) Connect to the report

2) It asks me my passward to connect to the source table of the chart

3) refresh the data

4) save the report

How can I do this programtically in VBA?

 

[jer99]

The properties tell me that it is

OLEUnbound
Class=Microsoft Office Excel 2003
OleType = Embedded
OleType Allowed = Either
classtype = Excel.Sheet.8

I don't know how to refresh it via VBA.
I can reference it by Reports!Audit_Report_Page_14!OLEUnbound335.<something>
But can't figure out what to do next.