SaveAs and Kill filename

Hi

I am having a bit of trouble with the below code. When I am killing the filename, there will always be two variations of the existing filename so I have added an error handler ie 'if the first file name doesn't exist, then try this one'.

This is a bit sloppy and I am getting an error 'Run-Time error '53': File not found' even if it has found the file and killed it. (The XXXXX is the filepath which I have redacted)

Is there a way to stop this happening? I would really appreciate your help.

many thanks in advance

Please Login or Register  to view this content.

Thanks, Norie.

I'm not too sure how to do this. I have seen previous posts by you advising how to use Dir (furiously Googling before posting), but I have struggled to find the right answer.

Could you possibly help me with a bit of the code? I just need the run-time error to disappear if the file is found, and to look for the other filename and kill if it is not found.

TIA, once again.

That worked perfectly. Thanks.

I just added the Dim strFile name.

Thank you once again.