Import Named Range from multiple Excel Workbooks

I have 50 of the same excel workbooks. These workbooks have named range I need to import into my Access Database. I have the code figured out to import all workbooks from a specific directory, but I need to import only the named range of each workbook. I don't know where in the code I can put that command.

The named Range is "Import_2013_1st_Qtr"

Here is the code I have now:

Please Login or Register  to view this content.

Any assistance would be great.... Thankyou

Wild guess...

Try adding a number sign (hashtag) and the named range after the file path.

Rather than "C:Myfile.xls"


Try "C:Myfile.xls#Import_2013_1st_Qtr"

If that doesn't work, maybe try an exclamation point instead of a number sign.

Or try

filename#{sheetName}!{Range}


(omit brackets).

That's how hyperlinks work. Can be "A1" range notation or named range. Not sure if access import uses same syntax but might be worth a try.