Hello guys.
I need help with a macro that achieves this: I have files with over 15,000/20,000 lines that are supposed to be uploaded to the system in independent 5000 line .csv files to the SAP system.
However, I have no idea how to do this. I've thought about it and really can't think of any solution via VBA.
Please I need your help! Files have a variable number of lines every day and it takes a lot of time to split them daily and manually.
I also need files to be named this way, imagine the original file is named ABCDE.xlsx, I would need the new files to be named ABCDE(1).csv, ABCDE(2).csv, ABCDE(3).csv, etc. depending on how many lines the file has. The last file can have less than 5,000 lines; just the maximum number has to be 5000.
I need help with a macro that achieves this: I have files with over 15,000/20,000 lines that are supposed to be uploaded to the system in independent 5000 line .csv files to the SAP system.
However, I have no idea how to do this. I've thought about it and really can't think of any solution via VBA.
Please I need your help! Files have a variable number of lines every day and it takes a lot of time to split them daily and manually.
I also need files to be named this way, imagine the original file is named ABCDE.xlsx, I would need the new files to be named ABCDE(1).csv, ABCDE(2).csv, ABCDE(3).csv, etc. depending on how many lines the file has. The last file can have less than 5,000 lines; just the maximum number has to be 5000.