General information
Category:
COM/DCOM and OLE Automation
Title:
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only