Computer Engineers

 
Home | Computer engineering other top | Fiber / Wireless / Copper Tran | Semiconductor engineering
  Position:HOME>Programming language engineeri>Article Content
Convert Excel to PDF
Source:Internet Author:Unknow Pubdate:2008-04-14  
VBWizzard (Computer) 12 Jun 03 17:28
Does anyone have VB source code to convert Excel documents to PDF.

I have Acrobat distiller installed.

Thx

callicospfx (Electrical) 12 Jun 03 22:08
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 (Electrical) 13 Jun 03 22:45

 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 (Computer) 15 Jun 03 7:32
Done this using VB, Excel and Acrobat Distiller, Thanks for trying to help
字串5

PeterSze (Computer) 21 Dec 04 3:52
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 (Computer) 21 Dec 04 17:22
I use pdf995. Check it at www.pdf995.com ;)



PeterSze (Computer) 21 Dec 04 19:26
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 (Computer) 22 Dec 04 3:27
Using PDF995, I record a macro in Excel and copy it's VBA code to use elsewhere.:

CODE

    Application.ActivePrinter = "PDF995 on Ne00:"
字串9

    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


(Click:

Previous:Visual Basic   Next:Automatic delete files
[Add TO Favorites] [TOP] [PRINT] [CLOCE WINDOWS]  
  Hot Article
·PIC code for triac light dimme
·Connecting a Footswitch to an
·Siemens s7-200 PLC & Visua
·TETRIS source code is availabl
·XML Files and Terramodel
·controlling GPIB from VBA
·LINKING MSC PATRAN WITH INTRAN
·How to interface RS-485 / Modb
·VBA WITH AB PLC
·SIEMENS: I/O, NCDDE AND DCTL
·getch() function
·Visual Basic Serial Comms To S
  Related Articles
·Automatic delete files
·Prolog help
·C win32 threads
·how to make use of the results
·GTCO-Calcomp & USB to serial a
·E1055: Unable to open 'windows
·MsgBox in VB6
·Anyone use LoadLibrary
·How to create a bootable PC ca
·Needed Help with SQL Syntax
·LPT port in VB 5
·Solving Equations
Power by DedeCms