En cours

A script to search through a Word Document and find data in a Table in the document


A VB script is needed to run in an Excel Macro that can look up a specified Word document (See Example attached). It needs to find a table that matches that in the example and pull out 4th column in the table for the matching row number.

Detail / Process Flow

1) Open the Excel and a Prompt for the Word file is presented on open for first time. Once selected this will not prompt for the second time open. That is it needs to save the selection for next time.

2) Script need to find the table that has 4 columns with those headings

3) Script needs to go to each row and test column 1 against the row 1 in the excel.

4) If script finds a match it needs to copy all in column 4 contents in its format back to the cell in Row 2 of the Excel.

Compétences : Excel, Visual Basic, Word

en voir plus : row 44, need to find a word, excel macro to word, vb in excel, to search, summary table, search match, save to excel, process flow, find data, data flow, macro script file, excel macro match data, excel macro row, excel number word, word macro basic, number word excel, excel format cell, excel cell format, search next, visual basic word find, format cell, find word word visual basic, look table excel, basic macro word find word

Concernant l'employeur :
( 4 commentaires ) Brisbane, Australia

Nº du projet : #2331862