Thread: Copy range to / from CSV file
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
blackbox via OfficeKB.com blackbox via OfficeKB.com is offline
external usenet poster
  
Posts: 59
Default Copy range to / from CSV file
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

Reply With QuoteReply With Quote