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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.