Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Automation - How do I quietly delete a worksheet
Message
General information
Forum:
Visual FoxPro
Category:
Windows API functions
Miscellaneous
Thread ID:
00195683
Message ID:
00198461
Views:
17
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform