vba to extract data from multiple excel files in 1 folder

[Peter083]

Hi, can someone please help me with the following. I have a number of excel workbooks in a folder. I am trying to extract the data from Sheet 4 (10 rows maximum) in each of these files into a separate workbook. Ideally the macro will only look at workbooks that are in this folder.

Any help or suggestions would be greatly appreciated.

Peter

 

[gallen]

Ensure the line is at the very top of the code window before any subs are written

 

[Adnan11]

Ensure the line is at the very top of the code window before any subs are written

Which line Gallen?

 

[gallen]

I assumed it was this line that was causing you issues

[COLOR=#333333]Private Const sPath As String = "C:\Users\naveed\Downloads\Buzzme-Reports-2" 'CHANGE THIS TO YOUR DIRECTORY PATH[/COLOR]

This line must be at the very top of the code window.