I've linked tables from Access into Excel spreadsheet ranges. What I've been trying to do is import the same ranges from other excel files that have the same named ranges. I've written some VBA code that goes through the excel file and names the ranges for me. But when I try to import the ranges, Access is only showing one of the ranges named using the VBA code. If I go through and name the ranges by hand and then try to import them, they work without a problem. Why are the ranges named using the VBA code not showing up in Access but the ranges named by hand are showing up? Thanks for any help.