I am using an “Invoke VBA” activity to perform some pivot table changes, sometimes there are some runtime exceptions. I am currently using a Sub and I would like to be able to throw the exception in Studio that I get when I run the VBA code. Is there a way to do this? Perhaps a MSG from VBA?
What exception u are getting?
I am not getting a specific exception, I am just wondering how to catch exceptions thrown from the vba code in studio?