cancel
Showing results for 
Search instead for 
Did you mean: 

VBA not responding in BPC Book Publishing

Former Member
0 Kudos

Is there a trick to running VBA inside of the BPC book publishing functionality? I cannot get excel VBA to execute when using the BPC publishing to generate a pdf file.

Any ideas?

Thanks,

Cary Schulz

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

I have tried to use this too in the past, but I think Petar is right that it will not run. I have tried many things but it seems like the BPC code is blocking custom macros during the publication process.

-Joost

Former Member
0 Kudos

You may need to check the BPC Notes or lob a question to the BPC support team, but I do not believe that VB code will execute during the book publication process. My general advice, which many designers do not appreciate, but it is generally not optimal to use VB code in the excel templates during ordinary BPC implementations. The code often slows the template processes, and causes headaches for a customer to troubleshoot.

But please check with Support for a confirmation of the use with BPC Publishing.