Hi there:
I have been trying to find a way to save a .xls workbook to a .pdf file.
Does anyone know if this is possible through vba / macro.
I know there are a number of products out there, but was trying to avoid the
purchase and code around it if possible.
Any suggestions appreciated,
Thanks,
David
vishwa - 30 Aug 2007 23:29 GMT
If you are using excel 2007, you can download the add in for this from
Microsoft website.
rgds
vishwa
On Aug 31, 2:50 am, Dave@Penske <DavePen...@discussions.microsoft.com>
wrote:
> Hi there:
> I have been trying to find a way to save a .xls workbook to a .pdf file.
[quoted text clipped - 5 lines]
> Thanks,
> David
Dave@Penske - 31 Aug 2007 14:14 GMT
Hi vishwa:
I should have been more descriptive. I am running 2000.
Any other suggestions?
Appreciate it!
Dave
> If you are using excel 2007, you can download the add in for this from
> Microsoft website.
[quoted text clipped - 11 lines]
> > Thanks,
> > David
Gord Dibben - 31 Aug 2007 00:03 GMT
I have had success with the free file downloads and instructions for use here
at Dale Nurden's site.
http://www.rcis.co.za/dale/info/pdfguide.htm
Saves first to single *.ps file which is then converted to *.pdf
Returns one PDF file from multiple sheets.
See also David McRitchie's site for alternatives to the above.
http://www.mvps.org/dmcritchie/excel/pdf.htm
Others have reported that PrimoPDF does a good job and is free.
Gord Dibben MS Excel MVP
>Hi there:
>I have been trying to find a way to save a .xls workbook to a .pdf file.
[quoted text clipped - 5 lines]
>Thanks,
>David
Dave@Penske - 31 Aug 2007 14:12 GMT
Thanks Gord.
I am running with xls 2000.
Have you found any success in batch converting multiple files or lets say a
folder of files from xls to pdf?
Ultimately that what I am trying to get to.
Dave
> I have had success with the free file downloads and instructions for use here
> at Dale Nurden's site.
[quoted text clipped - 22 lines]
> >Thanks,
> >David