Import multiple CSV files into multiple sheets in a single workbook

Hi there.

I have a requirement to import multiple CSV files with the exact same format into a single workbook, with each CSV equating to a new sheet that is then renamed to match the CSV filename.

I did extensive research and found this thread that appears to do what I want but for some reason it is simply won't work for me
http://www.excelforum.com/excel-gene...ml#post2367007

Please Login or Register  to view this content.

Before I get the obvious answers I have tried the following:
- Edited the file path to where my files are stored
- Turned off screen updating so that I can see what is going on
- Tried stepping through the code using F8 and no errors were identified, but it it did not loop so clearly didn't see the files

When I run the script I am getting no screen activity at all with nothing imported and no sign of life.

Only thing I can think of is the version of excel.....I'm using Office 365 (whatever version that means now).

Many thanks

mikeTron - Thanks for the response.

I've actually solved the problem now. For anyone else wanting to use the code in the future, you need to ensure that there is a trailing backslash "\" at the end of the file path that you are searching. Stupidly the answer was right in front of me with the comments even saying to do this.....DOH

fPath = "D:\Dropbox\_Opportunities\PriceFinder Results\" 'path to CSV files, include the final \

Code works Perfect folks.

Now that I have the script working I have noticed that if I import the files a second time and the worksheet already exists that it creates a second worksheet with a (2) appended to it instead of writing over the top of the existing data.

Any assistance in how to overwrite the existing worksheet would be greatly appreciated.