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.