| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copya and paste data pb
Hi,
I have an Exel 97 macro that has been working great .... since 1997. Now we have updated to Excell 2003 it is no longer working correctly. Basically it is jamming when I want to copy data (12 columns and 7000 rows) from FileA.CSV and paste into FileB.xls The problem is that when the macros pastes in the (semicolon separated) data from FileA.csv it doesn't get distributed into the cells. How can I force that ? Erasmus |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copya and paste data pb
Erasmus,
Add a line at the bottom of your sub like: Range("A2", Range("A65536").End(xlUp)).TextToColumns _ Destination:=Range("A2"), DataType:=xlDelimited, _ Semicolon:=True HTH, Bernie MS Excel MVP "Erasmus Bowen" wrote in message ... Hi, I have an Exel 97 macro that has been working great .... since 1997. Now we have updated to Excell 2003 it is no longer working correctly. Basically it is jamming when I want to copy data (12 columns and 7000 rows) from FileA.CSV and paste into FileB.xls The problem is that when the macros pastes in the (semicolon separated) data from FileA.csv it doesn't get distributed into the cells. How can I force that ? Erasmus |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copya and paste data pb
Perfect !
Thanks ! Erasmus "Bernie Deitrick" <deitbe @ consumer dot org a écrit dans le message de news: ... Erasmus, Add a line at the bottom of your sub like: Range("A2", Range("A65536").End(xlUp)).TextToColumns _ Destination:=Range("A2"), DataType:=xlDelimited, _ Semicolon:=True HTH, Bernie MS Excel MVP "Erasmus Bowen" wrote in message ... Hi, I have an Exel 97 macro that has been working great .... since 1997. Now we have updated to Excell 2003 it is no longer working correctly. Basically it is jamming when I want to copy data (12 columns and 7000 rows) from FileA.CSV and paste into FileB.xls The problem is that when the macros pastes in the (semicolon separated) data from FileA.csv it doesn't get distributed into the cells. How can I force that ? Erasmus |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How copy none excel data & paste in 2007 without overwriting data | Excel Discussion (Misc queries) | |||
| EXCEL PASTE DOES NOT CHANGE DATA - PASTE DOESN'T WORK! | Excel Worksheet Functions | |||
| filted data, copy and paste a col. puts data in wrong row how fix | New Users to Excel | |||
| Find, Match data and paste data between two workbooks | Excel Discussion (Misc queries) | |||
| Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
Linear Mode
