Franky27
12-07-2008, 12:54 PM
I have many workbooks in one folder.
I want to make a database connection by VBA with all the workbooks together (all the same structure).
Im using Excel 2007 and the source files in the folder are all 2003 .xls versions.
So when I open the Excel 2007 workbook (I want Pivot tables in it) i want to generate an automatic connection to the folder with all the data Excel workbooks and read it as 1 database.
I want to make a database connection by VBA with all the workbooks together (all the same structure).
Im using Excel 2007 and the source files in the folder are all 2003 .xls versions.
So when I open the Excel 2007 workbook (I want Pivot tables in it) i want to generate an automatic connection to the folder with all the data Excel workbooks and read it as 1 database.