I can't for the life of me figure out to reference an Excel chart in my Access form Unbound Object Frame using the "Sourceitem" property. I need to embed multiple charts (not just pictures of the chart)into my Access form using the OLE Unbound Object Frame. I have the "SourceDoc" property correct as this is just the filepath to my Excel file. However I can't seem to reference the specific charts on the worksheets (Which are seperate chart sheets from the actual data). Attached is an example of the non-workng code. It currently returns only the active cells in the worksheet. I've been struggling with this for days !!! Thanks.
*The Excel File Name = Spend Management 7-19-2010.xlsx
*The Worksheet(Chart Sheet) Name = Direct-Charts
*Chart Name = Chart 35
'.Visible = True
' Enable control.
'.Enabled = True
' Set Locked property to False.
'.Locked = False
' Allow embedded objects only.
'.OLETypeAllowed = acOLEEmbedded
' Specify the OLE server and the type of object.
'.Class = "Excel.Chart.8"
' Specify the file to be embedded.
'.SourceDoc = "G:\000_Supply Chain\Procurement-Corporate\Spend Management\Spend Management 7-19-2010.xlsx"
' Specify the Worksheet Item
'.SourceItem = "Direct - Charts![Spend Management 7-19-2010.xlsx].Chart 35"
' Create the embedded object.
'.Action = acOLECreateEmbed
' End With