Help to go through 86 spreadsheets copy data and then paste into active sheet.

Hi guys,

I have 86 spread sheets each containing data for 200+ inputs for a month of hourly readings (Basically the 86 spread sheets comprise all of the months for a 7 year period).
Basically what I want to do is compile all of the information for one input.

All of the spread sheets are in the same directory of a disk located in the FilePath

I have managed to find some code from looking around already and this is what i have managed to put together.

Please Login or Register  to view this content.

The problem is the For Each function would appear to be invalid for this procedure.

Any help would be greatly appreciated.


Thanks

Eliat

If you need any additional information please comment here and I will reply as soon as possible.

Hi guys,

I have managed to automate the process (to an extent).

I was wondering if anybody knew a fast way to open multiple .csv spread sheets (as said above I have 84). I could merge these spread sheets together to achieve the required results but if there is an easier solution inside the code that I have already written i would be very grateful if you could help me out

Range("Selected").Value is determine by a userform combobox that is populated by all of the possibly values in Column D of all of the .csv filed

Please Login or Register  to view this content.

Hopefully someone can help

Thanks in advance

Eliat