Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can't print Excel file created with COPY
Message
 
 
À
30/12/2013 10:47:35
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01591089
Message ID:
01591093
Vues:
83
This message has been marked as the solution to the initial question of the thread.
>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?
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform