Hi everyone, in the process of learning VBA and appreciate help on these great forums..
I have many xlsx files located in a folder, I'd like to:
Loop through each one, select the first 6 sheets, and save down as a PDF with the same name (can be in same directory or in a new folder)
For example Lemon,Liz.xlsx has about 10 tabs (could be more added later) but I want only the first 6 (will always be located first) to be saved down as Lemon,Liz.pdf then loop to the next name.
Thank you for any guidance.
Also, I posted this question here as I'm in a bit of a pinch and spreading out the resources