PDA

View Full Version : using MODI with Excel



philfer
05-09-2011, 03:24 AM
Hi,

I have set a reference in my VBA project to Mocrosoft Office Document Imaging 12.0 Type Library and am using th efollowing code :-

Dim miDoc As MODI.Document
Set miDoc = New MODI.Document
miDoc.Create ("O:\SSHEETS\testdoc.pdf")

but I get a runtime error :-

Run-time error '-959967229 (c6c81003)':

Automation Error

Other MODI code I have seen is the same as this. does anyone know why I am getting this error

Thanks
P

Bob Phillips
05-09-2011, 04:57 AM
Try doing it in Word.

philfer
05-09-2011, 08:52 AM
Hi,

I figured out why I was getting the runtime error.

It turns out MODI onyl works with .tif files and not .pdf or word files.

This leads to my next issue.........is there a way in VBA to convert a pdf file to a tif file?

Cheers
P

Bob Phillips
05-09-2011, 09:21 AM
Able2Extract seems to do that.

philfer
05-10-2011, 12:46 AM
Hi,

Do you own shares in Able2Extract!!!!

its a good piece of software but I work for a tight bunch of people so am trying to create a free solution.

There must be a way to write a tailored free solution to this

Cheers
P

Bob Phillips
05-10-2011, 12:50 AM
LOL! No I don't, but I use it and it has been extremely useful to me.

The problem with a tailored solution is catering for all possibilities in a PDF, you need to get the data structure details, and then write code to handle all things like paragraphs, images, and so on. NOt a trivial task.

Seriously, if you do a lot with PDFs, and they are ubiquitous, create a business case for buying some software. Show how it would be used, the time savings it would generate, cost that time and compare against the capital cost. It should be a black and white yes or no then.