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(or something close)
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.