cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
devipriyanka
Microsoft
Microsoft

Text is not getting detected

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.

 

devipriyanka_0-1664183879722.png

 

1 ACCEPTED SOLUTION

Accepted Solutions

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

 

View solution in original post

6 REPLIES 6
VJR
Super User
Super User

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

devipriyanka
Microsoft
Microsoft

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.

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
Microsoft

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

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

devipriyanka
Microsoft
Microsoft

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.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,602)