>>>>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.
Thanks Naomi and Mike.