Welcome to the forum, Joebarri. I see June7 has offered a partial solution. I also see that was your first post. For future reference, this section is just to say "HI." But we have many other technical sections that might be good places to post. Since you asked for VBA code, you would post in the "Modules and VBA" section. But don't worry, we don't penalize you for wrong-topic posting. If this thread grows, some moderator might just move it.
Try using the SEARCH feature of this forum, which can be found 3rd from the right in the thin menu-ribbon near the top of the page. You can find all sorts of subject matter on the topics of file-system operations and print operations.