>>>Hi All:
>>>
>>>I created an excel file:
>>>
>>>
>>>SELECT * ;
>>> FROM curCustItemPriceChanges ;
>>> WHERE salesman = curSalesman.salesman ;
>>> INTO CURSOR cursCopy
>>>
>>>lcFile = tcFolderReports + ALLTRIM(curSalesman.salesman) + '-pricing'
>>>COPY TO (lcFile) XLS
>>>
>>>
>>>When I open the file (in Excel 2010) and try to print, I get the following message on the print preview side:
>>>
>>>"microsoft excel did not find anything to print"
>>>
>>>Any ideas?
>>>
>>>Thanks,
>>>
>>>Yossi
>>
>>Try adding NOFILTER in your select statement and TYPE XL5. Also, did you verify that the file contains data?
>
>Changing to XL5 fixed the problem. I did not have to type NOFILTER. Thanks!
>
>Interesting - the XLS worked on my machine (Win 7), but not on the other (Windows Server 2008 R2 Standard).
Naomi is right though. NOFILTER is, to me, absolutely necessary. It is rare you will want to run a query and merely be seeing the actual table with a SET FILTER applied to it. That happens when FoxPro thinks it is appropriate which can lead to funky results.