Ignore/Disable VBA code in processbooks for Batch processing

Discussion created by aldorexbraam on Feb 11, 2013
Latest reply on Feb 20, 2013 by andrew_Inwood



I have a problem where I need some guidance from the community from:


Objective is to batch process a many (about 1000)  processbooks. For this I need to automate them using some VBA code that strips all VBA code from the processbook and does some further processing.


Problem is however that most of the processbooks allready contain VBA code that gets called in the Display_Activate or Display_Open events,   in most cases this code has failures errors causing the VBA debugger to break in that point. 


So what I want to achieve is a method that load the .PDI without VBA getting kicked off because that halts the processing until the VBA debugger instance related to the opened processbook is closed.