Thanks, Chip.
However, it is still not working as I get a "Reference is not valid" error
message in Access when I set the hyperlink subaddress field to
"Chart1.ChartArea.Name".
Any other suggestions?
Robert.
"Chip Pearson" wrote:
Try something like
ActiveWorkbook.Workbook.Sheets("Chart1").ChartArea .Name
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Robert" wrote in message
...
I'm writing an Access database with links to Excel. In my Excel
spreadsheet,
I have a chart that I would like the database to link to.
However, the Excel
chart is situated not into a part of a normal worksheet, but in
a separate
worksheet/tab of its own, if you know what I mean. The chart's
worksheet/tab
is titled "Chart1".
So, what subaddress should I use for Access to be able to link
to the chart
itself, rather than to the whole Excel spreadsheet? I tried
"Chart1", but it
doesn't work as I think the program is looking for a range such
as
Sheet1!A1:C10 or something similar that I don't have for the
chart.
Thanks in advance for your help.
Robert.