Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Open Excel in edit mode
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 5
Divers
Thread ID:
01209333
Message ID:
01209368
Vues:
19
This message has been marked as the solution to the initial question of the thread.
>Hi All,
>
>I'm automating Excel with Foxpro to open a excel 97 workbook,when opening it prompts a message if I want to open it in "edit" mode or "read" mode. How to supress the prompt and choose always for edit. I have somewhat the following code:
>
>
>oExcel = CreateObject("Excel.Application")
>oExcel.Workbooks.Open("f:\restposten.xls") && I get a prompt
>
Try to change
oExcel.DisplayAlerts = .F.
oExcel.Application.Workbooks.Open("f:\restposten.xls")
If it's not broken, fix it until it is.


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

Click here to load this message in the networking platform