Information générale
Catégorie:
COM/DCOM et OLE Automation
Titre:
Determine if worksheet already exists in Excel
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement