Hello All,
I am currently working on a project that exports multiple queries directly to a new Excel workbook. Once the query results are in excel the project formats each sheet exactly how I need it. But with all the different formatting and all the different sheets I have exceeded the procedure limits. Ive tried to split the procedure into a couple of different subs, but I cant figure out how to get the second process to identify the new workbook created by the first process. Any help you can provide will be much appreciated.
Thank you,