Good day. Thank you for the video very informative. The macros runs however it does not actually pull in the data from the csv file even though it states it has completed the merge. Any suggestions would be greatly appreciated.
Hi Jie, hoping you can help Thanks for the video/script, is there a way I can merge the files and keep the dd/mm/yy date format I received them in? When I merge it assumes US date format
I’m also getting the runtime error 1004. I copied the code exactly from your website and then made the necessary adjustments to my range. Still no idea what’s wrong.
Hi, very informative and thank you for the explanation. I have a question: what if my CSV files are not in the same column order and i only want to pull only some data from these CSV files to be merged in a excel table? what i want the macro to do is consolidate those data. Looking forward to hear from you!
If your columns' order are not uniform and you only want to merge few columns, my recommendation is write the VBA in a way that you copy one column at a time so your datasets will match when merging.
Hello, Thank you for sharing the useful video on csv merge files. I have a query here, as you are merging these csv files in the excel file where you have written the macro code. We have some different requirement where we want to store all the merged csv files in new excel file which we want to share it with stakeholder. so the output of merged csv file should contain only the data and not with the macro code. I hope you understood my requirement and will share the output . Thanks, Parag
Hi. I have done something similar in the past where you take a master excel workbook and create individual files based on a giving list. Unfortunately I currently don't have any tutorial video showing how to do that but I am planning to do one in the future.
i having some problem while runnign this vba code, im getting this error-run time error '1004', we couldn't find (xyz.csv).it is possible it was moved, renamed or deleted?. but not any issue is my folder path.... how to fix it. pl give the solution this query.thanks.
For those getting run time error or csv fine has been renamed or removed, kindly follow the process below Step 1 : Ensure that you save the excel master file as a macro-enabled file in the multiple csv files path directory. step 2: ensure that you change the file path by copying and pasting the new file path from your computer. step 3: ensure that you change the column range e.g A2: P
Hi! Thanks a lot for your tutorial! I also was looking for it for hours! But unfortunately I am getting one error where the macro can find the csv files to get their names, but at the point where it would import them into the new workbook it says it can't find the file haha. The error is: "Run-time error '1004': '111_02_03_2019.csv' could not be found. Check the spelling of the file name, and verify that the file location is correct. If you are trying to open a file from your list of most recently used files, make sure that the file has not been renamed, moved or deleted." As it says the name of the file which I did not specified on the code, I know that the first part of the code is functioning perfectly. It is something about when it tries to open the files! Can you help me?
I believe that Dir function returns only the file name, not the entire path. I Think Workbooks.Open(Path & Files) should to the trick. You can use the name only if the files are in the default file location (CurDir - to check this path).
Hey Jay, I have the same issue as multiple people in the comments about the csv file not being found. I sent you an email with my script. Could you take a look at it for me?
Usually when that happens, it is usually due to typos in the script. I'm currently busy with few projects and other things. My suggestion is to post your problem on ExcelForum.com and you should be able to find help.
Thanks for the great video! I am having an issue with my code. My implementation is a little different (I am loading file locations from a table in a different sheet) and I keep getting a run time error: "1004" on ".Range("A2:N" & last_row).Copy" Any thoughts? Thanks.
Hi Jie, im hoping you can help. I got the script to run initially. But now get errors. The environment is on my computer's local drive (both the macro file and the csv files). The folder for the csv files is in the same folder that the macro file is in. I changed the FolderPath to the csv files folder and included the backslash at the end, and I changed the columns from N to Z in both locations. The error i keep getting is "Run-time error '1004' Sorry, we couldnt find nameofcsv.csv. Is it possible it was moved, renamed or deleted?" When I debug it highlights Set wbTemp=Workbooks.Open (Files). Hovering over that it seems to see my file...so I dont know where to go from there
For those getting run time error or csv fine has been renamed or removed, kindly follow the process below Step 1 : Ensure that you save the excel master file as a macro-enabled file in the multiple csv files path directory. step 2: ensure that you change the file path by copying and pasting the new file path from your computer. step 3: ensure that you change the column range e.g A2: P
When I try to run this code I get an error ‘Sorry we couldn’t find “filename.csv”. Is it possible it was moved, renamed or deleted?” The files are in its place neither it has been moved nor deleted. Please advise what could be the reason.
For those getting run time error or csv fine has been renamed or removed, kindly follow the process below Step 1 : Ensure that you save the excel master file as a macro-enabled file in the multiple csv files path directory. step 2: ensure that you change the file path by copying and pasting the new file path from your computer. step 3: ensure that you change the column range e.g A2: P
