Hi
I am a novice VB scripter and have found various pieces of the jigsaw
puzzlei n this fantastic forum, but can't seem to piece it all together.

I would like to import a csv file with a variable name into a workbook. Then
modify the information and export a modified file of the same name from a
different sheet. A defined range of columns and a variable number of rows
would be exported. The workbook needs to retain its original name.

The filename consists of the following components:
Test-yyyymmdd-Batch.res.csv which may look like "ANA-20071201-1.res.csv".
Test and Batch are defined names.