VBA Code to Convert/Print Selected Pages of Word Document to PDF File

Originally Posted by DD1

If the Word document had more than 3 pages, is it possible when creating the second PDF file to print from page 2 to the end of the document?
I had a look at Word's ExportAsFixedFormat method but couldn't see that it was possible. I tried a couple of things, but wasn't able to get it to work.

That's easy: simply replace the '3' with:
.ComputeStatistics(2) '2 = wdStatisticPages

Originally Posted by DD1

Also, is it possible to append one pdf file to another with VBA? I would like to do this from Excel.
I can do it manually, but can't work out what the code is.

Not from MS Office. You could, however, automate Adobe Acrobat Pro and have it do that. Adobe Acrobat Pro 8 is available as a free download. I don't know the relevant Adobe code to combine files, but people on an Adobe forum should be able to tell you that (or a web search might turn up the code).