Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reading Excel graph sourcedata from Access
Message
General information
Forum:
Microsoft Office
Category:
Other
Title:
Reading Excel graph sourcedata from Access
Miscellaneous
Thread ID:
00729542
Message ID:
00729542
Views:
53
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
Map
View

Click here to load this message in the networking platform