Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Reading Excel graph sourcedata from Access
Message
Information générale
Forum:
Microsoft Office
Catégorie:
Autre
Titre:
Reading Excel graph sourcedata from Access
Divers
Thread ID:
00729542
Message ID:
00729542
Vues:
54
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
Fil
Voir

Click here to load this message in the networking platform