Create Excel to PDF by VBA

[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

 

[muddan madhu]

check it here

http://kb.adobe.com/selfservice/viewContent.do?externalId=328398&sliceId=2

 

[K]

check it here

http://kb.adobe.com/selfservice/viewContent.do?externalId=328398&slic....



- Show quoted text -

Thanks for replying muddan, but i need vba to do this job. and i
havent got acrobat, i just have normal adobe reader.

 

[muddan madhu]

may be this

http://www.tek-tips.com/viewthread.cfm?qid=416162

 

[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

 

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