Subject:
|
Re: Create bill of materials (.TXT file)
|
Newsgroups:
|
lugnet.cad.mlcad
|
Date:
|
Wed, 18 Feb 2004 19:00:11 GMT
|
Viewed:
|
5518 times
|
| |
|
|
In lugnet.cad.mlcad, Kevin Wilson wrote:
> ludo soete wrote in message ...
> > This list is a common .TXT file.
> > Now, i would like to import this file into Excel, but can't split the 'Color,
> > Part Number, Description, ...' into separate columns, without writing some VBA
> > code.
>
> When I try to open (not import) a MLCAD part list text file in my (old)
> version of Excel, it can tell that the file is Fixed Width and comes up with
> that wizard, which lets me set the widths and types of each column. It put
> some extra column dividers into the description column which I had to
> delete, but apart from that it deleted perfectly.
>
> Does this work for you or are you trying to do it all under program control
> with no user input?
>
> Kevin
Hi Kevin,
This aproach works fine on my PC too. Perhaps i did something wrong the first
time, but i stay at my idea of TAB delimeter files for the fact that it would be
easier to get every thing in nice columns. As you take a close look, you'll see
different column markers in the Wizard for the 'Description'.
With a TAB delimeter as column separator, the 'Description' would be always
filled into one column, even with double spaces in the Description text.
This would make it also a lot easier if we want to write some VBA code to
manipulate this file. I guess also that using a TAB would generate nice columns
when the TXT file is opened with NOTE PAD or WORD PAD so file names with 4
character (+ .DAT) & 5 character names (+.DAT) would be nicely placed under each
other.
So,i would apreciate it when Michael would implement a TAB to separate the text
into columns.
Regards and thanks for the reply,
Ludo
|
|
Message is in Reply To:
 | | Re: Create bill of materials (.TXT file)
|
| ludo soete wrote in message ... (...) 'Color, (...) VBA (...) When I try to open (not import) a MLCAD part list text file in my (old) version of Excel, it can tell that the file is Fixed Width and comes up with that wizard, which lets me set the (...) (21 years ago, 17-Feb-04, to lugnet.cad.mlcad)
|
4 Messages in This Thread:
 
 
- Entire Thread on One Page:
- Nested:
All | Brief | Compact | Dots
Linear:
All | Brief | Compact
|
|
|
|
