fantastic!!! thanks Borislav.
I don't understand the significance of the change you made, but i'm very happy it's working now.
k
>>thanks frank and borislav. still getting errors. Here's the whole thing with a recap of the errors i receive at the points i receive them.
>>when i continue and press ignore each, i end up with a page of dbf files to select from, so it is not finding the CTASK.DBF.
>>(and Yes it is in the correct directory) (I close all here to make sure there are no lingering selects open.) (When i select CTASK, the test.xlsx is not created.) (To test for interference from previous coding, i jump to this program at startup with the same issues.)
>>
>>thanks for your patience.
>>k
>>
>>close all
>>use CTASK in 0
>>SELECT CTASK
>>CopyToExcel("c:\DB\Test.XLSX", "Sheet1")
>
>
>Try:
>
>close all
>use CTASK in 0
>SELECT CTASK
>CopyToExcel("c:\DB\Test.XLSX", "Sheet1","CTASK")
>