Code to copy range from 200 + workbooks and paste into one csv import file

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

Hi
Have a look at this link which may help you:

http://stackoverflow.com/questions/3...-one-final-des

Good luck.
Tony