Add STRTOFILE() to your ON ERROR routine and record the error code and message to a file. Maybe it'll give you idea what the problem is.

>Wish I knew. I have an on error trap set up for the 'append' line. If it errors, I put out the message that it couldn't load. I know the table is open; I know the xl file exists and is available (I use the full path to the file). As I said, when I run it, it works properly. When he runs it, it errors out with my error message, and the table remains empty.
>
>I brought the code home and ran it here and had the same issue with it erroring out on my own pc. I just looked at the code I posted and it is not quite the same as in the compiled program. In the compiled code, it is:
>
>

Append from (lcClaimFile) type xl5 sheet "loss_run"

>Here at home, when I remove the quote marks from loss_run it works. For whatever reason though, at work, on my computer, the quote marks did not cause any problem. Tomorrow, I'll remove them, recompile and see if it fixes the problem on his system (and, of course, doesn't cause an error on mine).
>
>