Can anyone help to get me started?
I need to write a VBA prgram that will, upon activating,
prompt for a folder that store the Excel files to be processed.
Upon selecting the folder, it will then start processing all the files
in the folder one by one. The process can be as simple as opening the
file and copy the first line etc etc.

Challenge # 2, if it allows Control-Clicking the files selectively
in that folder and then process the selected ones it would be even
greater.