But do you open the csv IN Excel ?
If you open the .csv in another program before you copy, then Excel has no
way to know what you are doing.

Excel can open csv natively, in case you did not know.

NickHK

"blackbox via OfficeKB.com" <u20390@uwe wrote in message
news:73b9bdc68ef8e@uwe...
i recorder the macro in the xls, open the csv. copied, pasted to the xls

i had hoped it would recognize the different workbooks

NickHK wrote:
You are opening the .csv in Excel ?
If not, then E2:E22 means nothing.

If you are opening in Excel, then the macro recorder will get the file
name
and copy/paste actions.

NickHK

I tried to record a macro copying from the CSV and pasting to the xls
but got
an error message
[quoted text clipped - 31 lines]

Any help would be appreciated.

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