Hi,

I have an txt-file with 288 rows and 384 columns. I want to display these
value in an 3-d surface chart. It is not possible to load the complete file
due to the limitation of 256 columns of excel. Is it possible to load the
txt-file in two paeces with "OpenText" or is there another possible function
to achieve this?

Thanks

Even if you could load it, you couldn't display the data in a 3D surface
chart. A surface chart requires x values down one column, y values across a
row and Z values at the intersection. Doesn't sound like your data and it
it is arranged that way, you couldn't set it up on a single sheet.

You can open it with opentext by specify which columns to skip so that it
pulls in 256 columns or less on one pass and the remainder on another.

--
Regards,
Tom Ogilvy

"Pilgrim" wrote in message
...
Hi,

I have an txt-file with 288 rows and 384 columns. I want to display these
value in an 3-d surface chart. It is not possible to load the complete
file
due to the limitation of 256 columns of excel. Is it possible to load the
txt-file in two paeces with "OpenText" or is there another possible
function
to achieve this?

Thanks

Thank you for your help,

but how can I specify which column to skip with the opentext method and how
can I get access to remaining columns? Always when I load the first columns I
get no access to the remaining columns.

Thanks,

Simon

"Tom Ogilvy" wrote:

Even if you could load it, you couldn't display the data in a 3D surface
chart. A surface chart requires x values down one column, y values across a
row and Z values at the intersection. Doesn't sound like your data and it
it is arranged that way, you couldn't set it up on a single sheet.

You can open it with opentext by specify which columns to skip so that it
pulls in 256 columns or less on one pass and the remainder on another.

--
Regards,
Tom Ogilvy

"Pilgrim" wrote in message
...
Hi,

I have an txt-file with 288 rows and 384 columns. I want to display these
value in an 3-d surface chart. It is not possible to load the complete
file
due to the limitation of 256 columns of excel. Is it possible to load the
txt-file in two paeces with "OpenText" or is there another possible
function
to achieve this?

Thanks

Turn on the macro recorder and open a text file that only has a few columns.

in the final part of the text import wizard, identify a column or two to
skip.

then turn off the recorder and look at the code. The information is in the
array at the end of the OpenText command. The help file on opentext should
show you what they mean.

--
Regards,
Tom Ogilvy



"Pilgrim" wrote in message
...
Thank you for your help,

but how can I specify which column to skip with the opentext method and
how
can I get access to remaining columns? Always when I load the first
columns I
get no access to the remaining columns.

Thanks,

Simon

"Tom Ogilvy" wrote:

Even if you could load it, you couldn't display the data in a 3D surface
chart. A surface chart requires x values down one column, y values
across a
row and Z values at the intersection. Doesn't sound like your data and
it
it is arranged that way, you couldn't set it up on a single sheet.

You can open it with opentext by specify which columns to skip so that
it
pulls in 256 columns or less on one pass and the remainder on another.

--
Regards,
Tom Ogilvy

"Pilgrim" wrote in message
...
Hi,

I have an txt-file with 288 rows and 384 columns. I want to display
these
value in an 3-d surface chart. It is not possible to load the complete
file
due to the limitation of 256 columns of excel. Is it possible to load
the
txt-file in two paeces with "OpenText" or is there another possible
function
to achieve this?

Thanks

Thank you for your help!

Simon

"Tom Ogilvy" wrote:

Turn on the macro recorder and open a text file that only has a few columns.

in the final part of the text import wizard, identify a column or two to
skip.

then turn off the recorder and look at the code. The information is in the
array at the end of the OpenText command. The help file on opentext should
show you what they mean.

--
Regards,
Tom Ogilvy



"Pilgrim" wrote in message
...
Thank you for your help,

but how can I specify which column to skip with the opentext method and
how
can I get access to remaining columns? Always when I load the first
columns I
get no access to the remaining columns.

Thanks,

Simon

"Tom Ogilvy" wrote:

Even if you could load it, you couldn't display the data in a 3D surface
chart. A surface chart requires x values down one column, y values
across a
row and Z values at the intersection. Doesn't sound like your data and
it
it is arranged that way, you couldn't set it up on a single sheet.

You can open it with opentext by specify which columns to skip so that
it
pulls in 256 columns or less on one pass and the remainder on another.

--
Regards,
Tom Ogilvy

"Pilgrim" wrote in message
...
Hi,

I have an txt-file with 288 rows and 384 columns. I want to display
these
value in an 3-d surface chart. It is not possible to load the complete
file
due to the limitation of 256 columns of excel. Is it possible to load
the
txt-file in two paeces with "OpenText" or is there another possible
function
to achieve this?

Thanks