Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel Automation - How do I quietly delete a worksheet
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Fonctions Windows API
Divers
Thread ID:
00195683
Message ID:
00198461
Vues:
21
>When I create a new workbook, Excel automatically comes up with 3 worksheets. I only want 2.
>
>When I'm done filling in the first 2, i do a
>m.oExcel.Worksheets(3).delete()
>
>this works but the user gets an excel nag sheet asking them if they really want to delete the worksheet. i, of course, don't want them to see that.
>
>any ideas how i can delete that 3'rd sheet quitely (or maybe never get it to begin with).
>
>thanks
>
>scott vandenelzen
In Excel goto Tools , Options, General and change the value of Sheets on new workbook to 2.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform