For an unbound object frame what is the format of the .SourceItem property?
I have a chart in an Excel file which I am trying to reference as the source.
The chart is a Sheet called [Graphs] and the chart named is [Chart 1]
SourceDoc = C:\Users\Mal\Downloads\MapTransfer.xlsx
and I can't see what could be wrong with that, but I cannot reference the chart in that file:
I've tried:
Chart 1
[Chart 1]
[Graphs]![Chart 1]
[Graphs].[Chart 1]
Graphs!Chart 1
Graphs.Chart 1
MapTransfer.xlsx![Graphs]![Chart 1]
[MapTransfer.xlsx]![Graphs]![Chart 1]
and countless others but none seem to display the chart.
Other properties, which I think are right, but I give just in case they are aren't:
OLEType = Embedded
OLETypeAllowed = Either
OLEClass = Microsoft Excel 2003
Class = Excel.Chart.8
Both files are the most recent Office 365 releases.
I'm guessing the .SourceItem is not specified correctly. Anyone know how I should refer to the chart?
Mal
I have a chart in an Excel file which I am trying to reference as the source.
The chart is a Sheet called [Graphs] and the chart named is [Chart 1]
SourceDoc = C:\Users\Mal\Downloads\MapTransfer.xlsx
and I can't see what could be wrong with that, but I cannot reference the chart in that file:
I've tried:
Chart 1
[Chart 1]
[Graphs]![Chart 1]
[Graphs].[Chart 1]
Graphs!Chart 1
Graphs.Chart 1
MapTransfer.xlsx![Graphs]![Chart 1]
[MapTransfer.xlsx]![Graphs]![Chart 1]
and countless others but none seem to display the chart.
Other properties, which I think are right, but I give just in case they are aren't:
OLEType = Embedded
OLETypeAllowed = Either
OLEClass = Microsoft Excel 2003
Class = Excel.Chart.8
Both files are the most recent Office 365 releases.
I'm guessing the .SourceItem is not specified correctly. Anyone know how I should refer to the chart?
Mal