Create Excel to PDF by VBA
 

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

Create Excel to PDF by VBA
 

check it here

http://kb.adobe.com/selfservice/view...8398&sliceId=2



On Feb 9, 1:21*pm, K wrote:
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

Create Excel to PDF by VBA
 

On Feb 9, 8:37*am, muddan madhu wrote:
check it here

http://kb.adobe.com/selfservice/view...Id=328398&slic....

On Feb 9, 1:21*pm, K wrote:



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- Hide quoted text -

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

Create Excel to PDF by VBA
 

may be this

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


On Feb 9, 1:47*pm, K wrote:
On Feb 9, 8:37*am, muddan madhu wrote:

check it here

http://kb.adobe.com/selfservice/view...Id=328398&slic....

On Feb 9, 1:21*pm, K wrote:

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- Hide quoted text -

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

Create Excel to PDF by VBA
 

On Feb 9, 7:21*pm, K wrote:
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

Create Excel to PDF by VBA
 

On Feb 9, 1:21*am, K wrote:
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.