Ladies & Gents,

I use a macro which opens 3 files (A_acc.csv, A_warn.csv, & A_reject.csv),
formats & combines the files, then splits & saves them to 3 workbooks called
1_A.xls, 2_A.xls & 3_A.xls. The csv file names change daily. Other than
having to open & save each file individually, I have no problems. I wish to
update the macro so that I enter the file name, the macro then uses that
name to open the files, and save the new ones. Does anyone have any hints
that could help me?


Thanks in advance.

Andrew