PDF Question

[link9]

Hello all --

My company just purchased the adobe acrobat software package so that we can distribute reports in that format for printing purposes.

At any rate, the reports are currently run in excel, and the whole process is automated, and out pops the finished product (the .xls file).

They came to me and asked if I could write them a program that could take those .xls files and make .pdf's out of them.

I've seen posts of this nature before, so I told them that I could and I'm hoping that someone can point me in a good direction on where I might find the documentation on how this is done... (i.e. the syntax and other such methods for creating the objects).

Thanks in advance for any advice!
Paul Prewett

 

[MorganGreylock]

I think the easiest way to do this would be to link or embed the Excel spreadsheet in a Word document, then in Word, go to File/Save as PDF. When Adobe Distiller (PDF creator is installed, that option should appear automatically.)

I've never tried anything like that, but it seems like it should work.

 

[link9]

Well, you can save an Excel spreadsheet as a pdf directly from Excel...

But that still doesn't help me to find the library functions so that I can do this from inside a VB program (preserving any hyperlinks or whatever else there happens to be in the spreadsheet).

Any ideas on how to do that?

Thanks,
Paul Prewett

 

[chiph]

link9 -

Try reposting, with a subject of "Printing from Excel via VBA". You will probably get more responses that way.

Chip H.

 

[petermeachem]

I think its rather hard. You can do it via PHP ( a web scripting language ), but thats not much help to you. I think there are several different non Adobe programmes that will create a PDF. Perhaps there is a control?

 

[link9]

Actually, I found the adobe acrobat SDK for VB online at partners.adobe.com --

Time to dig in --

Thanks all