I have a problem that, I’m trying to work out, I have a database that imports a file everyday and appends the data to a table, all nice and easy but we are in the process of changing a few things at work and the report that I import will soon change names every day to the day before date. In the format YYMMDD this is a major problem for me. the only way that I can see getting it work is edit the macro every day with the new name.