[mick]

Thanks Erel. I'm almost there .I'm still having a bit of trouble because I'm first using
a variable to declare my file name.
MyFileName = "TestFile"
Suffix = ".txt"
If FileExist(MyFileName & Suffix) = true Then
MyFileName = "TestFile2"
That works Great,so when I try to inject the path like


MyFileName = "My Documents\TestFile"
Suffix = ".txt"
If FileExist(MyFileName & Suffix) = true Then
MyFileName = "My DocumentsTestFile2"
My error handler grabs it.
I Feel like such a pest here. I really do appreciate the amazing help I get here.
Thanks again Mick.