Code to get data from Word to Excel

  Monoux 22:04 13 Jul 2006
Locked

I’m looking for some help to create code to incorporate in a macro for the following. I have to scan forms which contain address’s then use OCR and save them as a word document giving each document a different three figure file name e.g 312 or 785. Each days scanning is saved to a folder made up of the date e.g. 13_07_06.
The maximum forms per day is 15

I then open the Word documents manually one by one and copy the data by using select all / copy. Each sheets data is then pasted to a separate sheet in an Excel spreadsheet.

I then use macros to sort the address’s as I need them to be.

I will obviously need to do the scanning and file saving manually but then I would like to automate the next part of the process. I need code to let me input the a date and therefore the folder to use, go to that folder open the first file , select/copy/ then paste the data to sheet one on the Excel spreadsheet. Go back and do it again (without the need to input the date again) for the next word document until all the word docs in that folder have been copied to Excel each to a separate sheet in excel.

Here’s hoping someone out there knows how this can be achieved TIA

  Woolwell 22:57 13 Jul 2006

I have OmniPage Pro 14 and with that I can open Excel and scan documents direct into eech separate sheet. This seems to do what you want without having to put it into Word, save and then copy across. Abbyy FineReader also allows me to scan direct to Excel.

  Monoux 07:33 14 Jul 2006

Woolwell-- Thanks for that I use Omnipage but its an old version and will only OCR to Word Docs.

Looks like I'll need to update unless someone can help me with the coding

  Taff™ 08:19 15 Jul 2006

click here for a Try & Buy version from Abbyy

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment utiliser Live Photos ?