Use 1 Macro across multiple workbooks located in a specific folder

[company1]

Hello Everyone,
I have a question regarding Macro's. I have seen a similar question posted here before but I'm afraid my knowledge was not as advanced as the person who asked the question, so i didn't really understand the response!
I have a Macro saved in my Personal.xls workbook that converts the content of a workbook into a format that i can copy and paste into a CSV to enable me to import the data into a database. Currenlty i open each workbook, run the macro, then copy and paste the results into a CSV file, this continues for each workbook which is up to 50 per day. I would like to apply that same macro to all workbooks that are saved in a specific folder. That way all i have to do is the copy and paste the results from each workbook into the CSV. Can anyone help me figure out how to do this? I am on excel 2007 and am pretty much a beginner i would say.
Look forward to any suggestions and thank you in advance.

 

[Comfy]

This will provide you with code for the loop:

Excel VBA: Loop Through a Folder of Excel Workbooks. FileSearch Method

All you have to do is update it with your directory and add the code you wish to run.