I want to code a VB button in excell to look at a specific dir, always filled with new .mdb files , and return text like the following

Access_file_name_01.mdb,Tablename_01
Access_file_name_01.mdb,Tablename_02
Access_file_name_01.mdb,Tablename_03
Access_file_name_02.mdb,Tablename_01
Access_file_name_02.mdb,Tablename_02

And so on, anyone know how to go about this