It would be awesome if there was a vba add in so that we could use vba macros to combine pdfs, without needing to save, open bluebeam and then combine files there.
you can. You can use the Stapler outside of Revu to combine pdfs. You don't have to open Revu to use it. You can find it in your Windows Start menu. There are some macros you can use within Revu as well. Search for Using Scripts in Revu in the help menu
This sadly only solves have the issue as far as my understanding and testing goes. Right now i have excel set up to trigger specific files in folders and merge them with the PDF create through excel. The code relies on an acrobat addin to open and combine the pdfs. While stapler allows me to combine files to do so i would need to open stapler and manually drag the files or write javas cripts to pull files a certain way and append my script as i make adjustments. Through excel vba it is much simpler if revu had just a vba item, such as acroexh.PDDoc.