Welcome to LEAD Support Forum Login | Register | Faq  

    LEAD Support Forum
  Resource to find answers and post technical questions about LEAD products.
Search    
   

Re: Automatically converting Excel file to PDF
Started by JohnChambers at 09-14-2005 11:45. Topic has 2 replies.

Print Search « Previous Thread Next Thread »
  09-14-2005, 11:45
JohnChambers is not online. Last active: 9/8/2005 5:31:36 PM JohnChambers

Not Ranked
Joined on 08-29-2005
Posts 2
Automatically converting Excel file to PDF
Reply Quote

I have inherited a VB application that uses ePrint. The program converts an Excel file to PDF. The application first dynamically creats a Word doc, then pastes the XLS into that doc, then prints the Word doc using the ePrint driver.

Is it not possible to write a VB app that simply opens the original Excel file and prints to the ePrint driver? Must we first paste the XLS into Word??

Can someone provide code for the solution I seek?


   Report 
  09-16-2005, 13:45
Otis is not online. Last active: 12/30/2008 8:52:10 PM Otis



Top 10 Posts
Joined on 10-19-2004
Charlotte, NC
Posts 309
Re: Automatically converting Excel file to PDF
Reply Quote

Thank you for contacting LEADTOOLS. ePrint is a printer driver and therefore requires that it be printed to. It does not have the capability of opening files directly and printing them. The reason that your application opens WORD first is because there is a Micorosft Office COM object that allows you to open/create WORD files and operate on them. The developer used this object to print the Excel document. If Microsft offers a COM object that does the same for Excel documents, you can probably do the same and bypass the WORD part of it but I do not believe this object exist which is why the programmer took that route.

 

 


Otis Goodwin
LEAD Developer Support
   Report 
  07-06-2007, 16:35
Jagat is not online. Last active: 8/18/2008 7:57:47 PM Jagat

Not Ranked
Joined on 07-06-2007
Posts 1
Re: Automatically converting Excel file to PDF
Reply Quote

Hi Can you pls share that piece of cde with me

 

Thanks

Jagat


   Report 
Post
LEAD Support Fo... » Developer » ePrint API » Re: Automatically converting Excel file to PDF

Powered by Community Server, by Telligent Systems