Scan to PDF, Access VBA or VB6

Since my users find scanner software to be too complicated, I would like to design a simple application to scan documents to .pdf files. One of the primary reasons I need to do this is so I can control where the document goes based on the user who is using the scanner.

I've experimented a little with some different code but I haven't found any optimal solution. It appears that my scanner only makes .bmp files if I use WIA in VBA. How can I convert the bmp to a pdf? Or do I need to convert the bmp to a jpg or tiff and then to a pdf?

I don't need the text to be searchable but it would be nice if you could highlight and select text in the document (certainly not required). I'm not going to be saving the document into the database. I'm just using Access because it's the coding environment I'm familiar with and my users are also familiar with Access.

Also, I do expect to use a scanner with an ADF so we can scan in multi-page documents.
LVL 4
HKComputerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
0
HKComputerAuthor Commented:
boag2000,

Do you know where I can find any documentating and examples of automating Paperport using VBA? Can I keep the users completely out of the Paperport interface?
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Jeffrey CoachmanMIS LiasonCommented:
I have seen this done but it is akin to writing your own Scanning program, which might not be worth the trouble...
But if you're feelin' froggy, here is some reading:
http://www.microsoft.com/whdc/device/stillimage/WIA-arch.mspx
http://www.dynamsoft.com/Products/WebTWAIN_FAQ.aspx#What%20is%20Dynamic%20Web%20TWAIN


Most Scanners (and scanning Software) have options that will literally give you the choices:
Scan to Fax
Scan to File
Scan to PDF
Scan to OCR
Scan to Printer

In your case, the user need only select "Scan to PDF".

I mean if one software product is to "Complicated", then try another one.
Most programs will have some sort of trial version so that you can test it.

You could build you own, ...but why reinvent the wheel, if a $49 program does the same thing?

;-)

JeffCoachman
0
Jeffrey CoachmanMIS LiasonCommented:
Clarification:

<I have seen this done, but in terms of programming, some are akin to writing your own Scanning program, which might not be worth the trouble...

Some SDK's/API's *are* simple, and will give you something like this:

Scan("DeviceName","Format","OutputFileName")
So here, this would be a function with three Arguments.
So in an actual App, the code would look something like this:
    Scan("ScanJet320","PDF","c:\YourFolder\YourPDF.PDF")

So check out the second link I posted, or Google for more.

;-)

Jeff

0
Gustav BrockCIOCommented:
Go and check out csxImage:

http://www.chestysoft.com/ximage/default.asp

It is not free but it will save you hours and hours of trouble because scanners and drivers often do not comply to standards. Also, support is excellent.
We used it for a commercial document store application which ran for years with zero issues.

/gustav
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
HKComputerAuthor Commented:
Looks like csxImage is the only "real" solution posted here. Thanks
0
Gustav BrockCIOCommented:
You are welcome!

Also, the support from Simon Chester of Chestysoft is excellent. Well worth the money you'll have to pay for a license.

/gustav
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Peripherals

From novice to tech pro — start learning today.