I am using Access 2003
On a form I would like to get a list of worksheets from a closed Excel workbook and then display the column headings of the worksheet that a user selects.
I have some VBA code that will work for an open workbook but wondering how to do this with a closed workbook?
Thanks in advance