Do you mean a second instance of Excel ?
Look in the task manager and see how many Excel you have.
Also post the code that you have for the opening and copy/paste so far.
NickHK
"blackbox via OfficeKB.com" <u20390@uwe wrote in message
news:73c17573c07b2@uwe...
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