programmatically save xls file as pdf

[markfranklin]

Using Microsoft Report Generation Toolkit to create report.

Client wants pdf file not xls file.

Suggestions for programmatically saving xls file as pdf.

[Coq_Rouge]

The most used method to create a pdf file is to print the file as a pdf file to some storage media. Using some sort of pdf printer driver.

[alpha1]

Hi markfranklin,

You should be able to use Print Report.vi to select a PDF printer (including Adobe alternatives such as doPDF or PDF995). This method would require nothing more than just to have the PDF printer installed, and then adding the VI in your code.

[markfranklin]

Imtiaz,

Thank you, yes, I can have a pdf printer as the default printer.

I should have been move specific with needs.

I need to programmatically save as pdf to a custom folder location and custom file name, without a pdf printer popup box.

So the search continues....

[smercurio_fc]

---

markfranklin wrote:

I need to programmatically save as pdf to a custom folder location and custom file name, without a pdf printer popup box.

---

Please do a search in the forum. This question comes up quite frequently. The most recent was just a few months ago.

Message Edited by smercurio_fc on 09-28-2009 09:59 AM

[alpha1]

markfranklin,

Sorry I did make some assumptions there. I had a look at the low-level code for the Print Report VI and can't figure out a way to modify it to do what you want. Like Coq Rouge said, it would require a pdf printer driver for optimal integration. I did however find a third party PDF Toolkit by Simplicity AI which may suit your needs. It was coded for LabVIEW 8.6 and is available for free download from: http://www.simplicityai.co.uk/products_services/products/pdftoolkit/

I hope this will be of use.

[Coq_Rouge]

Here is a tool you may look at. http://excel-to-pdf-converter-pro.software.informer.com/ It is not free, and I have not used it myself. But I found it it my "might be useful" link archive

[markfranklin · Accepted solution]

Got excellent solution form Scott at NI - phonebank.

PDFCreator open source freeware + Active X code found at www.ni.com search create pdf.

Note that you will have to go in and update the Active X selection for each of these vi's, quick, easy, and free.

[Meng-Shiang.Lin]

Hi markfranklin,

Did you find this one? Could you please confirm?

http://decibel.ni.com/content/docs/DOC-4552

Adam

[wd8ivl]

---

markfranklin wrote:

Got excellent solution form Scott at NI - phonebank.

PDFCreator open source freeware + Active X code found at www.ni.com search create pdf.

Note that you will have to go in and update the Active X selection for each of these vi's, quick, easy, and free.

---

Hello List,

Can someone please post the exact link to the Active X above? 

Thanks,

Mike