Print word file and several sheets of Excel document via VBA


I've found the VBA script in de COM Script directory and can print a Word document via VBA. But I also want to print several sheets and merge it as one PDF document. I can't figure out how to do that. Can someone tell me how to change the script for this problem?

Currently I'm using PDFCreator 3.5.1.

Kind regards,