Convert Excel to PDF

[VBWizzard]

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

I have Acrobat distiller installed.

Thx

 

[callicospfx]

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

 

[Sett]

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.

 

[derrick]

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

 

[PeterSze]

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.

 

[cardoso115]

I use pdf995. Check it at

http://www.pdf995.com

 

[PeterSze]

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!

 

[johnwm]

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

    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:

http://www.essexsteam.co.uk