View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Jackson Jim Jackson is offline
external usenet poster
 
Posts: 324
Default Print Worksheet to PDF Files

I have been able to get this to work. Still working on the PDF. I know it
can be done.

ActiveSheet.PrintOut , prtofilename:="Microsoft Office Document Image Writer"
--
Best wishes,

Jim


"equity7252" wrote:

Please provide vba code to create PDF files for each worksheet in a workbook.

Each PDF file (using CutePDF) will be titled according to the contents of a
cell

This sounds very easy, but I've had much trouble in executing.