linking excel sheet to access using code
 

Hi I am working on a project that requires a excel
worksheet linked to a access table, this
worksheet/workbook is created and renamed each time is it
possible to link a worksheet as a table using code.
I want to give the user the ability to select a workbook
to link.