Please, show me your code.

>if i close all before and select myfile i get alias does not exist.
>if i open the file first then follow with select myfile i get error on this line shown below with 'table number is invalid'
>

>m.llOpenedtvWorkArea = .F.
>	IF !USED(m.tvWorkarea) AND TYPE("m.tvWorkArea") = "C" AND FILE(DEFAULTEXT(m.tvWorkarea,"DBF"))
>

>>

>>select myfile &&.dbf Remove the extension. ALIASes doesn't have one.
>>

>>
>>>am giving it a try but i am doing something wrong here
>>>select myfile.dbf gives me an error message
>>>select 0 use myfile,dbf give me a table number is invalid message.
>>>
>>>what am i missing.
>>>
>>>k
>>>
>>>>>thanks Borislav, i read that - WAY over my head.
>>>>>k
>>>>>
>>>>>>>Me again answering some of the issues in my first problem.
>>>>>>>if i open the file the re-save with format number 51 it will save as an xlsx.
>>>>>>>is there a way of doing this using the copy method without going through the opening xl method.
>>>>>>>
>>>>>>>k
>>>>>>
>>>>>>Check Using Excel 2007 File Formats in VFP 9.0
>>>>
>>>>You need only CopyToExcel function (but you need to add the whole file in your project).
>>>>Use it like this:
>>>>

>>>>SELECT YourTableYouWantToExport
>>>>CopyToExcel("c:\Test Craig's BLOG\Test.XLSX", "Sheet1")
>>>>