Hi all,

I'm wondering if there is a way to verify the existence of a "tab" in excel, the package that I'm working with does :

- drops the "summary" tab within the excel file
- recreates the tab
- populates the tab with the results of a query to a table in the db

This usually works fine since the users are not supposed to move or delete the excel file, but you know users, one of them deleted the file and of course the package failed since it tried to drop a tab on a file that doesnt exist, therefore my question, is there a way to:

[IF TAB DOES EXIST THEN] <- Whishful Code
DROP TABLE [Results] <- Actual Code

Thanks to all in advance

Luis Torres