Import Data From Multiple CSV's and Append into Single Sheet

[Tellm]

I have a series of comma delimited CSV files which I need to import on a regular basis and would like to automate the process.

The number of files I import varies from 1 to 20 but their structure are identical except for the content. The data I need to extract starts at line 9 and can vary between 1 and 300 lines within the file.

I recorded a macro but I am now stuck as to how I can get this to loop through each of the files and append the data to the bottom

Please Login or Register  to view this content.

Any assistance in this matter would be greatly appreciated.

Thanks

[Mandeep Baluja]

You're not on correct way !! Create a New workbook put this code in the module, Put the folder path in code and run it

Please Login or Register  to view this content.

[Mandeep Baluja]

You're not on correct way !! Create a New workbook put this code in the module, Put the folder path in code and run it

Please Login or Register  to view this content.

[Tellm]

Mandeep - thanks for the response. However, although I beleive I have followed your instruction I seen to get all the files opening up rather than 1 file with the contents of all the sheets. Any idea as to why?

[Mandeep Baluja]

Create a workbook remember your new workbook contains Sheet1 where data comes by this macro

Please Login or Register  to view this content.