Excel '97 text import problems:

[Danny]

Excel '97 text import problems:

I'd like to import a comma delimited .txt file with line break codes
for 'start new row' to my excel'97 worksheet.

Unfortunately it treats the 1st row of data as headings (as there
aren't any headings).

So:

1) I'd like the macro to treat all the file as data

And,

2) I'd also like to only select certain columns by their position.

Any suggestion gratefuly received and acknowledged.

many thx in advance

Danny

 

[Danny]

Update: I've compared the macro code...and the only difference is that
in the '2002 version it relates directly to the data.txt file using
'TEXT' when connecting up the file........Whereas the '97 code relates
to the .dqy file using 'FINDER' . I hope this helps explain my
problem..

TIA

 

[Danny]

Update: I've compared the macro code...and the only difference is that
in the '2002 version it relates directly to the data.txt file using
'TEXT' when connecting up the file........Whereas the '97 code relates
to the .dqy file using 'FINDER' . I hope this helps explain my
problem..

TIA