finenovembre
New Member
- Joined
- Oct 24, 2011
- Messages
- 4
hi
I'm italian
Someone could please write the code in vba to save every sheet in .pdf format in the same directory with its own sheet's name.
exemple of sheet name:
sheet 1 ---> bike
sheet 2 ---> Jenny
sheet 3 ---> house
I have to save in "desktop" all my .pdf file.
bike.pdf
Jenny.pdf
house.pdf
and at the end i have to print all this new pdf file
thanks you
I'm italian
Someone could please write the code in vba to save every sheet in .pdf format in the same directory with its own sheet's name.
exemple of sheet name:
sheet 1 ---> bike
sheet 2 ---> Jenny
sheet 3 ---> house
I have to save in "desktop" all my .pdf file.
bike.pdf
Jenny.pdf
house.pdf
and at the end i have to print all this new pdf file
thanks you