Covert PDF from Excel to specific location by Adobe PDF printer

shaif

Newbie

Join Date: Mar 2008

Location: Australia

Posts: 23

#1: Feb 2 '09

Hello Friends, I am facing a problem to create PDF from excel to specific location by using Adobe PDF Printer ib VB.

I used code:
Dim xlbook As Excel.Workbook
.
.
.
.
xlbook.PrintOut , , 1, 0, "Adobe PDF", True, True, "C:\Test.pdf"

Its work, But After make PDF I cant open the file , bacuse its say file is damage or corrupted.

Could any one please help me out the the proper solution.

Many thanks in advance.

« previous question | next question »

Similar Visual Basic 4 / 5 / 6 bytes

Access VBA - automatically printing reports to PDF at specific location (answers)
convert many excel files to pdf in batch (answers)
Access 2003, Question concerning Adobe Acrobat (answers)
Shelling out to Adobe (answers)

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,471 network members.