I had this problem (below) previously which you guys helped me with - the solution was SetWarnings to No - at the beginning of the macro. It worked in 2007 but I'm now on 2010 and I'm back to getting the "can't find the database file". Can anyone help please?
Thanks
I have a macro that imports a number of files from one source and places them in a single table. Not all the files come in at the same time but I need to start processing the ones that I do receive as soon as I get them. Currently, if a file has not yet been filed into the source the macro stops. What I need the macro to do is ... if x file isn't there - then continue. As I say the files come in over a period of days