Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Answer Excel prompt in code
Message
From
06/07/2005 15:17:31
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Answer Excel prompt in code
Environment versions
Visual FoxPro:
VFP 6 SP3
Miscellaneous
Thread ID:
01029661
Message ID:
01029661
Views:
53
Hi All,

I've created a program that opens an existing spreadsheet (basically a blank form), copies the worksheet and names the copy. The program will continue to add worksheets until the user has created all of their forms. THEN, I want to delete the "master" (blank) worksheet. I have the code correct for all of that, but I get this annoying little prompt...

Microsoft Excel
The selected sheet(s) will be permanently deleted.
-To delete the selected sheets, click OK
-To cancel the deletion, click Cancel
OK CANCEL

Can I respond to this (or just get rid of it) with code?

Thanks,
Martha
Next
Reply
Map
View

Click here to load this message in the networking platform