Hi there,
Im looking to create a script or executable that will split a csv file at row (n) and create two files from it
can anyone help??
If so its much appreciated
thx
Ade0282
Printable View
Hi there,
Im looking to create a script or executable that will split a csv file at row (n) and create two files from it
can anyone help??
If so its much appreciated
thx
Ade0282
I assume that this is to be done in the VBA Editor of Excel?
You can use the Split function to parse a delimited string. If you have the
row already in Excel then there really is no need to parse it when you can
just iterate through the cells in a loop or something.