callen2468
06-07-2007, 08:40 AM
I am having trouble writing a function to check the existence of a file. I searched several forums and a few books and so far have not found a good example of what I am trying to accomplish.
I have a procedure and some functions I use to check the existence of folders and create them if they do not exist. The procedure also creates a new workbook and saves it in one of the new folders. I am having some difficulty directing my FileExists() function to look in the correct folder for the existence of the file. Perhaps someone could take a look at this and point me in the right direction. I am self taught and have been working with VBA only a few years. I have several books and I pull as many examples from the online forums as I can. You have all been a great help and I appreciate it.
My project is too large to post here so I dummied up a workbook and some procedures and functions typical to what I am trying to accomplish.
Thank you in advance.
Chris
I have a procedure and some functions I use to check the existence of folders and create them if they do not exist. The procedure also creates a new workbook and saves it in one of the new folders. I am having some difficulty directing my FileExists() function to look in the correct folder for the existence of the file. Perhaps someone could take a look at this and point me in the right direction. I am self taught and have been working with VBA only a few years. I have several books and I pull as many examples from the online forums as I can. You have all been a great help and I appreciate it.
My project is too large to post here so I dummied up a workbook and some procedures and functions typical to what I am trying to accomplish.
Thank you in advance.
Chris