Help....

I need help or some example on how to generate Excel files based on
one main Excel file. The main Excel file once executed (manually)
will read a text file and grab each consecutive records and generate
another excel file with the name taken from the record read in the
text file...

Any help is greatly appreciated...

regards, Chris