Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> Microsoft ISV Community Center Forums >> Visual Basic for Applications (VBA)

Multiple Excel Sheets to PDF

Hey all,

I'm trying to get multiple excel sheets and two embedded Word files in the excel Workbook to print to a single PDF file. I'm using Office 2003 and VBA/6 that comes with it, and Adobe Standard 6.0. I've tried using the

Sheet10.PrintOut

and the ActivePrinter varient to select Adobe PDF, but I can't get it to work, I've tried

Sheet10.PrintOut (,,,,Adobe PDF,,,)
Sheet10.PrintOut (,,,,"Adobe PDF",,,)
Sheet10.PrintOut ,,,,"Adobe PDF",,,
Sheet10.PrintOut ,,,,Adobe PDF,,,

and none of them will work.. any help here would be much appreciated, I've spent all day trawling the web looking for a solution.

DaveSmile

[844 byte] By [Dave.Punk.Emo] at [2008-1-5]
«« How does clicking 'Home' icon helps in refreshing the page?
»» ListView to add a text and a label to a row
Microsoft ISV Community Center Forums
Visual Basic for Applications (VBA)

Microsoft ISV Community Center Forums Hot Topic

Microsoft ISV Community Center Forums New Topic

Microsoft ISV Community Center Forums

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified