How to write VBA to link Excel spreadsheets: A.xls, B.xls, C.xls .... n.xls to respective tables Tbl_1, Tbl_2, Tbl_3 .... Tbl_n and then create an Union Query on all this tables.
The number of Excel files is a variable, so the number of linked tables are variable as well. Excel File A.xls will be linked to Tbl_1, B.xls to Tbl_2, etc...n to Tbl_n automatically (using a button).
Thanks.
The number of Excel files is a variable, so the number of linked tables are variable as well. Excel File A.xls will be linked to Tbl_1, B.xls to Tbl_2, etc...n to Tbl_n automatically (using a button).
Thanks.