What code should be written in a VBAProject document (Excel)?

The program allows you to scan the selected folder for the presence of word files (application forms of applicants, the design of which can be arbitrary) containing fields corresponding to the fields of the table in the file after the files are found, the data from them should be copied into a table (including photos).

  • Specify what you have already done, what problems you see. It's just that no one will write a program for you here. - Yuriy SPb ♦
  • If you are given an exhaustive answer, mark it as correct (a daw opposite the selected answer). - Nicolas Chabanovsky ♦

1 answer 1

If you are interested in a general algorithm:

  1. Find files * .doc ( Dir function, for example)
  2. Each file:
    1. Open
    2. For each parameter of interest (age, name, photo):
      1. Find by adjacent keywords (or the first image in the document)
      2. To copy
      3. Paste into the desired cell of an open Excel document
    3. Close the file and go to the next one.

If you are interested in a ready-made program - form a technical task, contact freelancers.