Information générale
Titre:
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.
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement