I assume the files are Excel (.xlsx) not executables (.exe). Yes, you can automate importing of Excel files with any name given they are in a known location\folder.
You would loop through all files in said folder, if file is an Excel file (you can even check for keywords -
Code:
If Instr(sFileName,"Inventory") >0 Then 'this is an inventory file
) and import the first sheet (using sheet index instead of sheet name to deal with the inconsistencies).
Here are some links:
https://www.datanumen.com/blogs/impo...-access-table/
https://www.access-programmers.co.uk...ectory.135603/
Show us what you have tried if you get stuck.
Cheers,