Create Excel to PDF by VBA

  • Thread starter Thread starter K
  • Start date Start date
K

K

Hi all, I have normal Adobe Reader 7.0 installed on my PC. Is there
way to create PDF files of excel sheet or specific excel sheet range
from excel VBA. Please can any friend help
 
Hi all,  I have normal Adobe Reader 7.0 installed on my PC.  Is there
way to create PDF files of excel sheet or specific excel sheet range
from excel VBA.  Please can any friend help
Click to expand...

Use pdf creator....unless of course you have excel 2007 and it's just
a saveas.....

You need to set up your printable area and then print to the pdf
printer....

If you want it to look nice there are a few tricks...

If you are using excel 2003 or below, then sometimes you might want to
output it into word first and then print it..

Just a few lines of vba....

Regards,
Tom Bizannes
Sydney, Australia
 
Hi all,  I have normal Adobe Reader 7.0 installed on my PC.  Is there
way to create PDF files of excel sheet or specific excel sheet range
from excel VBA.  Please can any friend help
Click to expand...

VBA cannot create a pdf on it's own, I use a free version called "PDF
ReDirect", been using it for years
I have heard xl'07 has it's own pdf creator and you may be able to use
VBA to manipulate it.

If you have a PDF creator, then you can just use your macro recorder
set set the print driver.
 
Back
Top