Print to PDF  
Author Message
FREEMAN





PostPosted: Thu Aug 16 20:01:58 CDT 2007 Top

Excel Programming >> Print to PDF

I'm running '03 version of Excel and I need to know how to print a worksheet
to PDF via VBA code. I don't want the user to have to save the file, but the
code will save it in a predetermined location.

I've got an adobe printer installed that will work if I use File\Print and
print to the pdf writer.

Thanks in advance,
Chad

Excel185  
 
 
James_Thomlinson





PostPosted: Thu Aug 16 20:01:58 CDT 2007 Top

Excel Programming >> Print to PDF Check out this link...

http://www.excelguru.ca/node/21
--
HTH...

Jim Thomlinson




> I'm running '03 version of Excel and I need to know how to print a worksheet
> to PDF via VBA code. I don't want the user to have to save the file, but the
> code will save it in a predetermined location.
>
> I've got an adobe printer installed that will work if I use File\Print and
> print to the pdf writer.
>
> Thanks in advance,
> Chad
 
 
Chad





PostPosted: Thu Aug 16 20:05:17 CDT 2007 Top

Excel Programming >> Print to PDF Perfect, thanks!




> Check out this link...
>
> http://www.excelguru.ca/node/21
> --
> HTH...
>
> Jim Thomlinson
>
>

>
> > I'm running '03 version of Excel and I need to know how to print a worksheet
> > to PDF via VBA code. I don't want the user to have to save the file, but the
> > code will save it in a predetermined location.
> >
> > I've got an adobe printer installed that will work if I use File\Print and
> > print to the pdf writer.
> >
> > Thanks in advance,
> > Chad