Merge Multiple CSV files to one XLS with multiple tabs

[waqar.b85]

Hi guys,

I tried the code below in Excel 2010, however, unfortunately, for me it does not seem to work.
I changed the path to where my csv files are stored (i tested with different csv files). Whenever I run the macro, it seems to open up the cvs files from teh folder i mentioned in the code, that's all it does I do not see the CVS files being merged into one XLS files as different sheets.

Please help

Please Login or Register  to view this content.

[Kenneth Hobson]

Click the # icon and paste code between tags.

[waqar.b85]

Sorry, didn't realise i missed the code

[Kenneth Hobson]

The code should work though I would add a line after the ActiveSheet.Move line.

Please Login or Register  to view this content.

[waqar.b85]

Hi Kenneth,

I get a runtime error when i run the code with the line above.
It says "automation error" at that line when i run it

Thanks

[Kenneth Hobson]

You have something else going on I guess. It works fine for me.

Please Login or Register  to view this content.

You could check to see if the workbook was opened by:

Please Login or Register  to view this content.