Text is not getting detected

[devipriyanka]

Hi,

I am trying to read the content in a word document. Using recorder, I was trying to capture the text in that document, but it is not detecting. I tried adding the action 'click UI element in window' manually and also logged into power automate desktop as an administrator.

Kindly help me with this. Thanks in advance.

[VJR]

Will recommend to use Vbscript or a VBA macro to read Word documents in an easier way.

[devipriyanka]

Hi @VJR ,

I need to read some fields in a table from the word document. It contains both vertical and horizontal headers, due to this I am not able to read the specific fields if use Vbscript. Could you please let me know, if there is any other approach for this.

Thanks.

[VJR · Accepted solution]

Hi @devipriyanka 

You will find tons of code available on the internet (either VBA or Vbscript). Since PAD cannot call a Word VBA you can write an Excel VBA macro to read the Word and paste it into Excel.  PAD will call this macro and then Read Excel as Datatable. Just search for either/or - "vbscript/Excel VBA macro to read table from word document"

Some links below.

https://www.youtube.com/watch?v=GtHN0VnmgzA

https://www.encodedna.com/excel/extract-or-copy-table-data-from-word-to-excel-using-vba.htm

[devipriyanka]

@VJR , Thanks a lot 😊. It is solved my issue.

[VJR]

That's great @devipriyanka. Do share which solution worked for you for future members landing on this page. Thanks.

[devipriyanka]

Followed the link https://www.youtube.com/watch?v=GtHN0VnmgzA, it was clearly explained how to read the data from tables in a word document using excel vba. Thanks.