5 Replies Latest reply on Feb 20, 2013 10:12 PM by ainwood

    Ignore/Disable VBA code in processbooks for Batch processing

    aldorexbraam

      Ls, 

       

      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.