Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Determine if worksheet already exists in Excel
Message
From
18/07/2005 17:28:18
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Determine if worksheet already exists in Excel
Miscellaneous
Thread ID:
01033660
Message ID:
01033660
Views:
63
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
Map
View

Click here to load this message in the networking platform