PDF plotting
 

Hi there.
I have one Excel file, with a number of different spreadsheets within that
one file.
Currently, when I plot a PDF of my Excel file, one PDF file is created
wherein all my spreadsheets can be viewed, but within that one file.
I want make a PDF plot of these different spreadsheets, but when they plot,
they must be separated into different PDF files
e.g. Spreadsheet 1 must be plotted as a file called PDF1.pdf,
Spreadsheet 2 must become another file called PDF2.pdf,
Spreadsheet 3 must become yet another file called PDF3.pdf, etc.
Please advise on how I can achieve this.
Thank you...

PDF plotting
 

Print Sheets, not Workbook.

Muhammed wrote:

Hi there.
I have one Excel file, with a number of different spreadsheets within that
one file.
Currently, when I plot a PDF of my Excel file, one PDF file is created
wherein all my spreadsheets can be viewed, but within that one file.
I want make a PDF plot of these different spreadsheets, but when they plot,
they must be separated into different PDF files
e.g. Spreadsheet 1 must be plotted as a file called PDF1.pdf,
Spreadsheet 2 must become another file called PDF2.pdf,
Spreadsheet 3 must become yet another file called PDF3.pdf, etc.
Please advise on how I can achieve this.
Thank you...