I manually created an import specification for one Excel Spreadsheet. It works perfectly for that one spreadsheet.
How can I use that Import Specification (the same structure) but a different (700 different) Excel.xls names.
I want to do this using vba.
Thanks
Kody_Devl