First thanks for all the great information I've recieved from these forums.
My situation is this, I have multilpe filesthat need to be manipulated every day. Some need to be renamed and moved to folder "A" while another may need to be moved to Folder "B" with no name change then yet another file may need to be to be copied to folder"A" and "B".
I've built one macro that looks for the first file, does what it needs to do with it, then looks for the next file and so on. My problem is there may be times that a file may not be there and this is causeing the macro to error out and quit.
Is there some way to run a macro that can perform in "steps". Recognize if a "step" is performable, if so complete it and continue, if not, skip it and still continue. I thought the If file Exits or If file does not exist were my answer but I have not been able to get the macro to continue either way.