Copy PrintAreas/Ranges to a new workbook, do something with it, close and kill

[SeniorNewbie]

Hi out there
sorry, guys, I feel a bit lost in paradise, and Eve, that beast, has stolen all the apples. But maybe you can help me. My actual goal is to create a multipage PDF.

My idea: a workbook with several tables, for each of which print areas are defined. Now I want to copy the tables whose names start with “_” into a second workbook, save this as a PDF and then delete the workbook again.
My previous VBA attempts have all failed.

Can someone help me with a working snippet / or a better method
Many thanks in advance

Newbie sen.

 

[SeniorNewbie]

Thank u guys for the high attention to my question ... I found a much better solution.

 

[jolivanes]

For people that have the same or similar problem and are looking for a solution, like you did, and end up here hoping to find a solution, would you be so kind and show us what you found to be "a much better solution".
I am sure that this will be very much appreciated by these people.

Thank you very much.