This routine works fine in Win7 but throws an nil object error at the line

ifnot f1.Exists Then

This was with 2012R2.1. I rebuilt it with 2011R4.3 and the same thing still happens. The code was originally developed several years ago an an XP machine. The updated program has some features that I'm afraid won't work if I have to go back several years to fix this.

The recordset returns a valid path that exists on the computer. I'm looking for suggestions for a work around.

This routine works fine in Win7 but throws an nil object error at the line

ifnot f1.Exists Then

This was with 2012R2.1. I rebuilt it with 2011R4.3 and the same thing still happens. The code was originally developed several years ago an an XP machine. The updated program has some features that I'm afraid won't work if I have to go back several years to fix this.

The recordset returns a valid path that exists on the computer. I'm looking for suggestions for a work around.