Working on a macro in excel. Have a list of files on a sheet, program goes through and opens those files (it does things with those files, but that is irrelevant).
My problem is that not all files may exist. So, before the entire program runs, I want a form to pop up listing the files that couldn't be found. I'm thinking that it runs through the list and for those it finds, it marks the next cell over - when it's done, it looks and whatever files aren't marked, they get listed in the form.
My solution is to go several tedious loops, but I'm hoping someone has a better idea.
thanks
My problem is that not all files may exist. So, before the entire program runs, I want a form to pop up listing the files that couldn't be found. I'm thinking that it runs through the list and for those it finds, it marks the next cell over - when it's done, it looks and whatever files aren't marked, they get listed in the form.
My solution is to go several tedious loops, but I'm hoping someone has a better idea.
thanks