Thank you for the reply.
Great minds must think alike, because that is exactly what I ended up doing, and it worked perfectly.
The file was getting locked somehow, and I am still not sure how I would fix it, but I am happy with the workaround.
Nice of you to take time to help.