Hi ALL !!!

  Can somebody help me. I need to make PDF file from Excel
  using VB.

  Thanks for any suggestion !!!!!

DPK..

__________________
DPK..

PDFs (in any environment) are created by printing to the "printer" that is actually the PDF creating software. You add this through the Add Printer process in the start menu of Windows. Once added, it can be selected as the printer of any Windows program.

So, from VB you would call Excel’s printing process, specifying the PDF printer driver as the printer. (Since this is a Print-To-File operation, I’m sure there will be a need to supply the destination file.)

Thanks Brian for your reply,

can u give me that printing source..
how can i give the print command from vb..

thank you very much...

DPK..

Purchase Adobe Acrobat would be one way.

There are clones available, some are free. I don't know the name of any of them.

Once you "install" the software, you would go to Start > [u]S</u>ettings > [u]P</u>rinters. In the dialog that opens double-click the “Add Printer” icon, or select it then hit “Enter.” Add the PDF creating driver as a printer. Then all applications will have that “Printer” available in their list of available printers.

Regarding your question, “how [sic] can i [sic] give the print command from vb” I need to ask, “How are you handling the contact with the Excel resources (*.xls, etc.)?” Are you using a Excel.Application object?