Import text from a text file between 2 sentences

[hunk_1990]

Hello,


I want to import certain text from a text file which is between 2 sentences. Sample text:-
****Begin: 8.3 Naming Convention


Path: HKLM\system\currentcontrolset\control\filesystem\ntfsdisable8dot3namecreation
Value: 0
Interpretation: 8.3 Naming Convention enabled
****End: 8.3 Naming Convention

I would like the text to be imported to excel so that i get the text between the Begin and the End sentences. Sample Output:-

Column A
8.3 Naming Convention
8.3 Naming Convention

Column B
Path: HKLM\system\currentcontrolset\control\filesystem\ntfsdisable8dot3namecreation
Value: 0


I was looking if we could use a macro to do this, as we have to import 30 sections from 1 document for 3000 txt files !

Thanks for your help in advance !