Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Correct syntex for deleting a sheet in excel
Message
De
22/03/2001 16:34:44
Jonathan Cochran
Alion Science and Technology
Maryland, États-Unis
 
 
À
22/03/2001 15:34:13
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00487767
Message ID:
00487785
Vues:
13
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?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform