×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Convert Excel to PDF

Convert Excel to PDF

Convert Excel to PDF

(OP)
Does anyone have VB source code to convert Excel documents to PDF.

I have Acrobat distiller installed.

Thx

RE: Convert Excel to PDF

I have distiller also, from Excel, this allows a <Print> to PDF, once the print setup has distiller selected as the print device.

Doug Calli
Callico Special Effects

RE: Convert Excel to PDF


 you have to find an ocx that let you make a pdf files. So, you get excel data and write it using ocx's method.

RE: Convert Excel to PDF

Done this using VB, Excel and Acrobat Distiller, Thanks for trying to help

RE: Convert Excel to PDF

derrick, you said you can use these three object s can convert excel to pdf in VB, right. Can you tell me how to do it? Please give me the sample please.

RE: Convert Excel to PDF

Hi cardoso, I try this before. It is a printer driver which for convert Excel to PDF. However, I want a DLL or OCX which I can use it in .NET program which can convert the Excel report to PDF for output. Any suggeston? Thanks anyway!

RE: Convert Excel to PDF

Using PDF995, I record a macro in Excel and copy it's VBA code to use elsewhere.:

CODE

    Application.ActivePrinter = "PDF995 on Ne00:"
    ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
        "PDF995 on Ne00:", Collate:=True

Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting

UK steam enthusiasts: www.essexsteam.co.uk

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources