Saving corresponding filesnames within a Macro

[grafx77]

I'm currently working with this simple macro:

Please Login or Register  to view this content.

This simple macro is basically taking my pre-existing .csv files lableled submissions1-9.csv with a total of 45 rows per each .csv and spliting them up into 3 separate .csvs of 15 rows and saving them individually.

I need a solution to where I can open my .csv files, for example, one is named submissions6.csv and the macro will automatically save the 3 split .csv files as submissions6-1.csv, submissions6-2.csv, submissions6-3.csv and repeat the process for other .csv files I open.

IDEALLY >> if there is a way to take it one step further and have the macro open multiple .csv files, example: submissions1-9.csv and split up EACH ONE, that would be great!!

[HaHoBe]

Hi, grafx77,

maybe try this (untested):

Please Login or Register  to view this content.

Ciao,
Holger

[grafx77]

Thanks for the help Hahobe, and you almost have it, but when splitting up my main .csv it separates the 3 csv files into 1 with 15 rows, 1 with 30 rows, and 1 with 45 rows. The macro I was using, split up the main csv into 3 separate csv files each containing 15 rows. Example:

1st csv was row 1-15
2nd csv was row 16-30
3rd csv was row 31-45

So almost there.....probably just needs a little tweeking.

[mohan.r1980]

Hello grafx77

Assuming that you have 45 data
Please try this code


'

Please Login or Register  to view this content.

[HaHoBe]

Hi, grafx77,

change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Ciao,
Holger

[grafx77]

+1 to HaHoBe!

Thanks bud! Works like a charm now!