I'm not that good at automating .pdf from excel and when i had to do
something like that i was saving each .pdf as separate files (what
your current code would do) and then combining them together from
within Excel by automating the .pdf as oppose to writing all the
sheets into a single .pdf to begin with.
You can try googling 'automate pdf excel' or something similar.
Unfortuanatelly i haven't saved that code of mine and currently my pc
doesn't have any .pdf autmation installed and hence i can't even try
replicating it for you...

When you do it manually - i.e., when you manually create a pdf from
within your excel - can you actually get all the sheets into a
single .pdf file? If so, then try recording macro while doing that and
then edit as necessary.


On Oct 1, 12:00*pm, Seanie wrote:
Thanks for your reply, ideally I would want each sheet to be a new
page on the PDF file