Copya and paste data pb

[Erasmus Bowen]

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

[Bernie Deitrick]

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>

[Erasmus Bowen]

Perfect !
Thanks !

Erasmus




"Bernie Deitrick" <deitbe @ consumer dot org> a écrit dans le message de
news: %[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
>