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.

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.

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.