Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Correct syntex for deleting a sheet in excel
Message
From
22/03/2001 16:34:44
Jonathan Cochran
Alion Science and Technology
Maryland, United States
 
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00487767
Message ID:
00487785
Views:
14
Here's some code we use for deleting sheets.
ll_Old_DisplayAlerts = lo_Excel.DisplayAlerts
lo_Excel.DisplayAlerts = .F.
DO WHILE lo_Excel.Sheets.COUNT > 1
   lo_Excel.Sheets(2).DELETE()
ENDDO
lo_Excel.DisplayAlerts = ll_Old_DisplayAlerts
>Hi All, I am trying to delet a sheet in a 95/97 work book. I can delete the sheet but I get a warning dialog box, is there anyway from preventing this dialog box from coming up?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform