Start by recording a macro whilst perform those actions.
This will give you the basic code.

If the filenames remain constant, that will work.
If they change each day, check the help for GetOpenFileName and incorporate
it into your code.

NickHK

"blackbox via OfficeKB.com" <u20390@uwe wrote in message
news:73ac6c266f472@uwe...
I receive a CSV file each morning and have to copy range E2:E22 and copy
it
to a XLS sheet (calculator) range H2:H22 then copy I2:I22 form the XLS
sheet
to a second CSV file range F2:F22.

I assume that this is probably not too difficult but not quite sure where
to
begin, other than the macro would have to be in the XLS file.

Any help would be appreciated.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200706/1