You're describing a process we use here. The only difference is that we use OmniPage to OCR the PDF files. One time purchase of like $150 with unlimited file use.
Whenever I've tried to read the contents of PDF files in VBA it seems like it was horrifically complicated. The problem is worse if you don't know the source of the PDF.
I build an Invoice approval system here. A scraper routine pulls files out of Outlook messages and saves them into a folder...
Within our inventory here, I have a table 'Part' which identifies what an item is. Then I have another table, 'SKU' that specifies a way that item may be sold. So, SKU might contain Part#1 as a 'PackIn' of 6. A Part class handles translation between the different levels.
Prices require...
Hello everyone.
I've been searching around for a VBA class that neatly handles JSON data. I'm wondering if anybody here has a class module that they've been using for a while and are entirely satisfied with.
My searches thus far have turned up some code that appears to handle parsing very...
If the code in the form isn't terribly long and doesn't reveal any "corporate secrets," would you be willing to post it here?
Also, I'm curious about the key structure of the table that's getting modified. What data type is the primary key field?
Is it possible to set the Executable to be the name of the .BAT file, and get rid of the arguments parameter?
The bat file *should* run without having to open up a CMD window. You just wouldn't see the results on screen I think.