AnsweredAssumed Answered

How to remove VBA Code, Modules and References from a PI ProcessBook file programatically?

Question asked by BrentAWebster on Jul 14, 2016
Latest reply on Jul 22, 2016 by pthivierge

Good afternoon all,

 

I have multiple modules to create multi state objects based on an excel spreadsheet.

There is one sheet per module per display.  The multistates are created for up to 50 different objects with up to 40 states.

 

The modules work great on their own.  I just want to either attach reference and modules programatically and remove when done or create some sort of addin that has the excel reference and code all avalible

 

Has anyone programatically added a reference to excel and imported modules then deleted modules and the reference to excel

 

Message was edited by: Patrice Thivierge - Changed the question title from "multiple modules for creating multi state objects" to "How to remove VBA Code, Modules and References from a PI Processbook file programatically?".  To make it easier to find later on. The question should also be: How to generate PI ProcessBook files programmatically and remove all code content from the generated file?

Outcomes