I'm trying to automate PDF Converter 6 Enterprise in Access 2007 VBA via the API layer. I managed to get a PDF from Nuance tech support that documents the methods available in the API layer but only gives examples in C++. I am not a C++ programmer but the Nuance document claims the API layer is available to any programming language supporting OLE automation. My goal is to convert PDFs to Excel spreadsheets, capture the data and store it in an Access database. I actually have all the individual parts working but I need to automate the call to the PDF Converter API layer.
If anyone has had any experience in this I sure could use some vb/vba method examples to open, convert, close pdf docs using vb/vba. I have attached the Nuance PDF doc.
So you want to export the pdf file to Excel and read the data to insert into your database?
Looks like Example #2 on page 44 would be a good starting point but without the program I can not tell what menu items are available to you.
I would assume there is an export to Excel menu item and from that invoke the menu item, output to Excel and read the pdf contents to insert to your database table.
Thanks for the response. I've read the document from top to bottom a couple of times and I have managed to invoke one menu item but that is as far as I can get using that interface. If you take a closer look at the documentation you will see that there are several interfaces available. I particularly want to get at the file level interface where it appears all methods for automation would be available. However, as I stated in my original post, all the examples are in C++ and of not much use to a VB/VBA programmer. What I specifically need are VB/VBA examples to instantiate and use methods in the file level interface.
Well, first I would need to know how to instantiate and reference the PDF Converter objects using the file-level interface. Basically, I want to start the app, open a pdf passing a path variable, convert it to Excel, and finally close the app. All of this should occur seemlessly and without any user intervention since this will be automated on an unattended timer. Thanks for your efforts.
Hello, Please let me know if some one worked on this and the question is Solved. I am trying to automate Nuance through macro and I am not sure what reference dll should be Selected.
I know i am posting on a Dead Thread. and Sorry for that.
Reply With Quote
