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