Check a Range for file name existing and if does exit and if not call another macro

[bdouglas1011]

I have code that creates a excel sheet and saves it to a FilePath and name it:

Please Login or Register  to view this content.

I need to search for that Filename on a sheet (Survey Email) Range CY30:CY43 If the file exists then exit sub if not call ShowFolderContents

Any Ideas

[JEC.]

Just a guess (this code needs to be combined with your code, the fname has to be specified)

Please Login or Register  to view this content.

[bdouglas1011]

I like how if the file is not there it added it to the range but when that happens I need to call another (Call ShowFolderContents)

If the file already is there I do not need to call the macro.

The reason for calling another macro is there are check boxes on the right and the left of the range that have to be selected if they want to include that file in other macros.
Once it is there the file gets overwritten many times a day so no need to recheck it would have already been done the first time.

it does not call the macro as of now when the file is not present