Answered

Text is not getting detected

(0) Share

Report

Posted on by devipriyanka Microsoft Employee

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.

Categories:

Power Automate Desktop

All responses (6)

Answers (1)

Sort by

VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Will recommend to use Vbscript or a VBA macro to read Word documents in an easier way.
devipriyanka Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.
Verified answer

VJR 7,635 on at

Like
a
(1)

Report
Copy link

Link copied!

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 Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

@VJR , Thanks a lot 😊. It is solved my issue.
VJR 7,635 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Like
a
(1)

Report
Copy link

Link copied!

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.