I am a newbie in excel macro. I need to extract "meta tag keywords" and "description" from 100s html files from my local directories and sub folders.
I need data to be listed in three columns in excel sheet: file path, keywords and description. May somebody here help me out with this complicate job? Thank you.

As you know, my meta tag shows like the following:

<title>Get Paths And keywords</title>
<meta name="Keywords" content="Get Paths, keywords">
<meta name="description" content="macro to Get Paths And keywords">