Extract Data from specific places in multiple word files to excel

[youbitto]

Hello MrExcel Genuises

I have Multiple word Files that has some data that I need to extract to excel

the documents has over 40 pages and the data I need are in separated pages

I am Asking if there is a way or macro in excel to that work automaticaly

here an example in word :

what i want to be filled in excel

Nouveau Feuille de calcul Microsoft Excel.xlsx
	A	B	C	D
1	Name	Age	Birth	Adresse
2
3
4
Feuil2

Thank you

 

[hungtbatman1]

there is hte file uploaded in one drive
https://1drv.ms/w/c/b601c788cb3f645c/ESsXjx7AzXJHlmoVGizVseAB6nHwdaNo7hVLG06BuuDe2w

I looked at the image and thought there was a space " " before the colon. In fact, it is "hard space" (code point = 160).
Change

regex.Pattern = "^" & a(col - 1) & " *:(.+?)$"

to

regex.Pattern = "^" & a(col - 1) & "[ \t\xA0]*:(.+?)$"

The new code accepts space " ", TAB, "hard space" - [ \t\xA0]

 

[youbitto]

I looked at the image and thought there was a space " " before the colon. In fact, it is "hard space" (code point = 160).
Change

regex.Pattern = "^" & a(col - 1) & " *:(.+?)$"

to

regex.Pattern = "^" & a(col - 1) & "[ \t\xA0]*:(.+?)$"

The new code accepts space " ", TAB, "hard space" - [ \t\xA0]

Thank you Mr.hungtbatman1 It works now perfectly

 

[NdNoviceHlp]

@hungtbatman1 care to share some comments and indicate what your code is doing and why all the cryptic use of CHR? Dave

 

[hungtbatman1]

@hungtbatman1 care to share some comments and indicate what your code is doing and why all the cryptic use of CHR? Dave

why all the cryptic use of CHR?

I don't know what this is about, I don't know what CHR is. Can you explain?

 

[NdNoviceHlp]

Please don't take offence, I would just like to understand your code. I know what Chr is but why use it in this fashion? Dave
eg.

.Title = Chr(83) & Chr(101) & Chr(108) & Chr(101) & Chr(99) & Chr(116) & Chr(32) & _
             Chr(70) & Chr(105) & Chr(108) & Chr(101)

 

[hungtbatman1]

Please don't take offence, I would just like to understand your code. I know what Chr is but why use it in this fashion? Dave
eg.

.Title = Chr(83) & Chr(101) & Chr(108) & Chr(101) & Chr(99) & Chr(116) & Chr(32) & _
             Chr(70) & Chr(105) & Chr(108) & Chr(101)

Please check. This is not my code. My code does not have CHR.

 

[NdNoviceHlp]

Well my bad. I can understand your code. My apologies. Thanks for the clarification. Perhaps @Sam_D_Ben can provide us with some enlightenment. Have a nice day. Dave

 

[Sam_D_Ben]

Well my bad. I can understand your code. My apologies. Thanks for the clarification. Perhaps @Sam_D_Ben can provide us with some enlightenment. Have a nice day. Dave

Hi Dave how are you, "that is to prevent something" , hope you know it. Have a good one !

 

[NdNoviceHlp]

Nope don't know. No longer care. Thanks anyway. Dave

 

[Sam_D_Ben]

Nope don't know. No longer care. Thanks anyway. Dave

That sounds final—hope everything's okay. Let me know if you need anything.