Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel automation
Message
De
10/02/2004 08:15:40
 
 
À
09/02/2004 15:30:45
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00875617
Message ID:
00875840
Vues:
18
>I am doing ole with fox to automate excel. Everything is fine until the user make some change and don't apply the change to the cell (doing enter key or mouse click on the green arrow or on the red X to confirm the change).When this append any code doing ole with excel hang waiting for Excel reply.
>
>I must find how to tell to Excel to apply the change before doing anything else. I am searching in activecell, activeworkbooks ............
oExcel.DisplayAlerts = .F.
This should avoid (ignore) Excel prompts. I use it when saving, to avoid Excel's prompt "do you want to save xxx?" It would probably do what you want.


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform