Browse Word Document data into excel sheet

Hi Team,

1) I need to Browse the Folder to select a particular file (user Choice)
once selected it should copy all data from word file & paste it in Excel sheet("A1")

2) after which it sorts
3) Plot formula to track if the Column D have value greater than 0

Column should result if any cell in column d have value greater than 0


I have some code..I am able to sort it via code..

But cant get through folder select & paste word data in excel.. & plotting formula..
I tried seqarching for code.. but couldnt get through right one
Please assist

Thank You



Below is the code for folder select & select a file.. but how to modify it so that word data gets pasted in excel A1

Please Login or Register  to view this content.

I got this code which copies the dsata from word to excel.. but it prompts that Doc file is in use..
Unless i click any radio button it wont move ahead.. how do i ignore this automatically..

Please Login or Register  to view this content.

Got it the below code copies all word contents in each specific sheet.

Please Login or Register  to view this content.