How to convert Word/Excel files to .PDF using VB automation

[netizen]

Hi!
As the subject says, I want to open Word/Excel files using common dialog and on a click of button want to convert them into PDF and save it in a given location, all this using Visual Basic automation with Acrobat object library.

Any sampe would be greatly appreciated.

Thanks,
Netizen

 

[SBendBuckeye]

Do a Google search on GhostScript. Something is tugging at the back of my mind that it does something like that and may have some sample code. Sorry that I can't be more specific.

Also, set a reference in your project to your Adobe library and use F2 to look at its objects. Assuming that it exposes an Application object, you could also do something like this and use View Local Variables to nose around a bit: Set obj = CreateObject("Adobe.Application").
Good Luck!

Have a great day!

j2consulting@yahoo.com