M
Mark S via AccessMonster.com
I have a form that has an embedded linked Excel Chart in it. I want to create
multiple charts in Excel and link them to different worksheets within the
same workbook. Is it possible to link to a specific worksheet? If so what is
the correct syntax? In the properties sheet I am using
C:\Stats Project\Combined ADH CORE.xls. But I don't know how to reference a
specific worksheet.
As always...Thanks for your help.
BTW....I realize I can create charts in Access. Excel charts provide more
flexibility for my needs.
multiple charts in Excel and link them to different worksheets within the
same workbook. Is it possible to link to a specific worksheet? If so what is
the correct syntax? In the properties sheet I am using
C:\Stats Project\Combined ADH CORE.xls. But I don't know how to reference a
specific worksheet.
As always...Thanks for your help.
BTW....I realize I can create charts in Access. Excel charts provide more
flexibility for my needs.