i do open it in excel, however I have been opening it in a second excel
window so I can view them side by side.

is that the problem?

NickHK wrote:
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

i recorder the macro in the xls, open the csv. copied, pasted to the xls

[quoted text clipped - 13 lines]

Any help would be appreciated.

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