Sorting

[seathestars]

Hello,

I currently have folders organised;

Month > Day > Excel File

I have 2 years worth of data like this with over 650 files, each Excel file holding 8 rows and 8 collumns filled with data.

I am looking at a mass upload proccess that can put all the data into one file?

Thanks

[mrice]

Use the folder contents listing macro available on my download page and then run the following macro.

Please Login or Register  to view this content.

[seathestars]

Hello Mrice,

Thanks for the reply but can you provide a link to your download page with the folder content macro.

Kind Regards
STS

[seathestars]

Mrice,

I have succesfully added all the files, can you instruct me on how to run a macro thank you so much.

[seathestars]

Mrice,

I have tried the Excel help with little hope, when I run the Macro a new document opens up but everything is just blank.

[mrice]

MY mistake - I missed out a line.

Please Login or Register  to view this content.

The macro needs to be in a module in the workbook that has the list of folders/files.

[seathestars]

I am getting an error 400 coming up?

[mrice]

When you get the error and hit DEBUG, which line is highlighted?