I have a Excel 2000 Spreadsheet with 21 worksheets.
I want to a have a single linked table within a Access 2000 database which I can point to each worksheet in turn then carry out a few actions.
However, when I repoint it in code its says I cant change the worksheet name (ie the Database Table in MSysObjects) once the Excel file location is set!
Does anyone know how to repoint a linked table to a different worksheet within the same spreadhseet using code?
Regards,
Dalien51
I want to a have a single linked table within a Access 2000 database which I can point to each worksheet in turn then carry out a few actions.
However, when I repoint it in code its says I cant change the worksheet name (ie the Database Table in MSysObjects) once the Excel file location is set!
Does anyone know how to repoint a linked table to a different worksheet within the same spreadhseet using code?
Regards,
Dalien51
