Excel and or Frontpage Macro

I need to create a Macro. Not sure if this would be done in Excel or Frontpage:
The macro needs to be able to do the following.

1. Scan a pre-determined folder or folder structure and open up the files located within the specified folder in notepad.
2. Perform a search within each file within the specified folder and look for the following text within the code of each page:
Date Submitted: (then the next 10 characters)
The file names and Dates Submitted (and 10 characters) would then be dumped into a .xls

this is very advanced for me and I cant really find anything that comes close.