Prevent publishing code to worksheets that don't exist

[hectorticoli]

Hi chelh,

I work with several versions of files, with different worksheets, and same VBA code. I published a worksheet that didn't exist in the Office file. It gives the following result:

You can notice the icon related to Feuil4, and the (Name) property that doesn't match (actually, it is "ThisWorkbook"), and the worksheet can't be deleted.

Thanks!

[hectorticoli]

Tested OK on version 2.1.2.

I know that's out of the scope of the tool, but can you tell me if that's possible to "clean" Office files from the "bad" imported sheets? Maybe as command-line, or as another tool?

Thanks

[hectorticoli]

Never-mind, I found a way to clean the file with version 2.1.2 (simply delete the file from the folder, and publish the change to the Office file) !