b1c11ap
09-12-2012, 03:34 AM
Help Needed;
I have different workbooks in .csv format. these are opened one-by-one using a code.
all the workbooks have only one worksheet (always).
the columns in all workbooks may be different. say there are 6 workbooks with 388 columns, 5 with 184, 3 with 233, etc. (these column numbers are examples only)
i wish to combine workbooks with same number of columns in a single workbook.
for this example, there will be 3 new workbooks.
would appreciate any help.
thanks
I have different workbooks in .csv format. these are opened one-by-one using a code.
all the workbooks have only one worksheet (always).
the columns in all workbooks may be different. say there are 6 workbooks with 388 columns, 5 with 184, 3 with 233, etc. (these column numbers are examples only)
i wish to combine workbooks with same number of columns in a single workbook.
for this example, there will be 3 new workbooks.
would appreciate any help.
thanks