Create Excel to PDF by VBA


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
 
Ad

Advertisements

S

SmartbizAustralia

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
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
 
Ad

Advertisements

C

CurlyDave

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
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.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top