Excel '97 text import problems:

D

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
 
D

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
 
D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top