| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
loading txt files with more than 256 columns
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| trouble loading excel files | Excel Discussion (Misc queries) | |||
| Is anyone else noting the slow speed of 2007 loading files? | Excel Discussion (Misc queries) | |||
| Loading Excel files | Setting up and Configuration of Excel | |||
| Excel Automation - loading text files | Excel Programming | |||
Threaded Mode
