Subject:
|
Re: Create bill of materials (.TXT file)
|
Newsgroups:
|
lugnet.cad.mlcad
|
Date:
|
Tue, 17 Feb 2004 21:21:24 GMT
|
Viewed:
|
5122 times
|
| |
|
|
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
-----------------------------------------------------------------------
Farmhouse kit: http://www.lionsgatemodels.com/cat-farm.htm
-----------------------------------------------------------------------
LEGO TOWN PLANNING information:
http://www.lionsgatemodels.com/COntent/Townplan/townplan.htm
BrickLink Lego parts store: http://www.bricklink.com/store.asp?p=Kevinw1
The Guild of Bricksmiths(TM): http://www.bricksmiths.com
|
|
Message has 2 Replies:
 | | Re: Create bill of materials (.TXT file)
|
| Kevin Wilson wrote in message ... (...) That would be, it IMPORTED perfectly. <sigh> Kevin ---...--- Farmhouse kit: (URL) TOWN PLANNING information: (URL) Lego parts store: (URL) Guild of Bricksmiths(TM): (URL) (20 years ago, 18-Feb-04, to lugnet.cad.mlcad)
| | | Re: Create bill of materials (.TXT file)
|
| (...) 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, (...) (20 years ago, 18-Feb-04, to lugnet.cad.mlcad)
|
Message is in Reply To:
| | Create bill of materials (.TXT file)
|
| Hi, I do have a remark, witch is at the same time a request. I'm creating a commuter train with MLCAD, and generate a parts list. This list is a common .TXT file. Now, i would like to import this file into Excel, but can't split the 'Color, Part (...) (20 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
This Message and its Replies on One Page:
- Nested:
All | Brief | Compact | Dots
Linear:
All | Brief | Compact
|
|
|
|
