>>I have a nice little Excel graph created using VFP code. It works great the first time. But the remaining Excel table won't allow VFP to overwrite the previous xls table produced using COPY TO. The message I get is 'Access Denied' when the overwrite is being attempted.
>>
>>Using VFP code, how do I get past the access denied situation and overwrite the old Excel table so the next chart may be produced?
>
>How did you create the first Excel file, using automation?
I used the Visual FoxPro COPY TO command to copy a VFP table to an Excel xls file:
Here is the code: COPY TO Graphtable TYPE XL5
I ain't skeert of nuttin eh?
Yikes! What was that?