Find a file in a director and return "true" if found

This should be pretty easy for all you VBA pros.

In a VBA Sub I create a file that its name is prefixed with a variable found in a cell. When the file is created a put it in a specific directory. This new code I want to develop looks for this file first before I create it again. The file can be found in:

C:\Users\Bob\Documents\"cellvariable" & code.txt

And "cellvariable" is a number found in a cell on a worksheet i.e. 12345. I simply want an IF statement that looks for the file in that directory, then if not found Calls another Sub that will then create the file. If found it does nothing meaning it does not create the file.

Thanks in advance.

Originally Posted by Mumps1

Can you post a copy of your file including the macro you are currently using?

Here is the code to create the file:

Please Login or Register  to view this content.

I do not have any code written to see if that file already exists in that directory: C:\Users\Bob\Documents\Debug\

The file itself is just a text file with numbers in it. The file will be "Cell D9"OutputdataCode.txt where Cell D9 is a number found in Cell D9 of the worksheet "Data Entry".

Does that help?

I did a combination of Mumps1 and GeneralDisarray, here is my final code:

Please Login or Register  to view this content.