Hi - I tried using a 'tool' / addon but when doing this - the xlsx file has the values but when there is leading zeros in a cell - the zero is stripped out by the addon so now I am thinking only a macro might be able to do this. I need something that would enable me to convert say 20 csv's into a single file but with multiple sheets within it.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Macro to convert multiple CSV's into a single xlsx file with multiple workbooks (each workbook is the name of the csv file)
- Thread starter kj9
- Start date
