@ssanfu, sorry, have been out of town for a few days. Firstly, I renamed the button to HolderBatchReport when I finalized the code Regarding the path, I just put hashtags to replace my username as I had some suspicious login activity one time when I posted to an excel forum a few years back... so I always do that now. I also did finish the path off with a \ as well as it kept wanting to write the filename including the folder name at the front. Took me a minute to figure that one out.
Interesting note about the ACViewPreview, it does make sense. Thanks again for your guys' help!