View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Copy range to / from CSV file

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