General information
Title:
Reading Excel graph sourcedata from Access
I have seen the .SetSourceData and .ChartWizard methods of the .Chart object in Excel. They can be used to fill in the source range for a chart. But what if I just want to read the current value? I'm doing that from Access using automation, to build some metadata for a workbook that has a bunch of graphs that may change. I can't find a property like ".sourcedata" or a method like ".getsourcedata" and it isn't the sort of thing you can easily discover using the macro recorder.
Thank you in advance.
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only