>What "refuses to load" mean? Error? Something else?

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).


>
>>My colleague uses a "command window" type program called X-Ray. It's actually pretty good. When he opens a table called 'lossrun' and types:
>>
>>

Append from "W:\import files\June032008.xls" type xl5 sheet loss_run

>>
>>the xl sheet gets appended into the table just as you'd expect.
>>
>>When I compile the code into an exe and he runs it, the [same] xl sheet refuses to load. When I run the compiled exe, it works properly for me - again, same xl workbook (on the network).
>>
>>I don't know if vfp is using the excel odbc driver, but for the record, I checked and he and I have the same odbc driver.
>>
>>The only real difference in our systems is that I have full vfp loaded and he has the vfp runtimes - both version 9. And it doesn't matter whether I code xl5 or xl8. Both work for me; neither work for him except when he types them directly into x-ray.
>>
>>Anybody got any ideas what might be going on here?