Hi All,

I need some code to combine information from various workbooks into one CSV Import File ...

Every Workbook is identical apart from their file names.
Each Workbook has a sheet named 'Inport' -I need to copy a range in this sheet from each workbook into the CSV inport ... Basically to save me going in to 300 workbooks individually and copy/pasting myself each range myself into the CSV!...

I've had a look on google at some examples of the code however they are all completely different and dont seem to work for me,

I can write some basic VBA but this is a bit more tricky

I would appreciate help from anyone.

Thanks,
Charlie Mappley