Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Office Automation Questions
Message
 
 
À
29/09/2010 15:53:50
Kevin Hickman
The Cadle Company
Ohio, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Novell 6.x
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01483222
Message ID:
01483254
Vues:
52
>I have two Office Automation Questions, One on Word and the other on Excel.
>
> In Word, if I issue the command oDocument.MailMerge.OpenDataSource('datasource.csv') , on some workstations it works fine, while on others it does not. They are all running XP and have all the office service packs up to date and the compatibility patch installed on both. Any insight as to why some do not work?
>
> In Excel, I copy data from a table in VFP as an .XL5 type because the .XLS type has a restriction of a certain number of rows it will copy. After I am done with what I do with the excel sheet, is there any way to save the workbook in a newer format without the prompt asking if the user wants to convert it to the newer format (as it does when the user would save it manually). I know the commands for save and saveas, but they do not automatically convert to the newer vesions.
>
>Thanks.

I believe SaveAs allows to specify version format. Also add DisplayAlerts = .f. for Excel object.
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