Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Determine if worksheet already exists in Excel
Message
De
18/07/2005 17:28:18
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
Determine if worksheet already exists in Excel
Divers
Thread ID:
01033660
Message ID:
01033660
Vues:
62
Hi All (and Sergey, of course!),

I'm saving data off to an Excel file. As I do this I am creating a new worksheet and naming it based on a name the user supplies.

IF the name of that worksheet already exists within that file I get a nasty little Excel generated message (very long and involved and probably not important if the following can be answered).

Is there any way I can check to see if a worksheet with the same name already exists before I rename the new, blank worksheet created?

Thanks for any help,
Martha Kroll
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform