alkaline55
New Member
- Joined
- Jan 24, 2020
- Messages
- 28
- Office Version
- 2016
- Platform
- Windows
Hi everyone, I'm still new to VBA and this is an interesting problem
Like the title says, I have many xlsx files located in a folder, I'd like to:
Loop through each one, select the first 6 sheets, and save as a PDF with the same name
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..
Any guidance is much appreciated!
Like the title says, I have many xlsx files located in a folder, I'd like to:
Loop through each one, select the first 6 sheets, and save as a PDF with the same name
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..
Any guidance is much appreciated!