help with templete

[Daniel M]

I have a project i am trying to do with a template. I have a cad package
that i can generate a bill of materials for and specify a template for. the
template seems to be pretty standard, some of the cells show to be
"column=count" or whatever the field in the cad package is. also some are
"field=xxxx". When i run this report from the cad package all is good.

The problem comes in because we have just switched cad packages. Now all i
can generate out of the cad package are text delimited (csv) files. Is there
a way to import this data into excel?

I would like to be able to specify columns in excel and have them match up
with the csv file. However the data will change from time to time so i dont
know how many rows i will need. the previous cad package/template didnt seem
to specify this. I have tried but i cannot figure out how the previous
package did it unless it was something integrated into the package.

Thanks for any help you can give.

dm.
(e-mail address removed)

 

[Dave Peterson]

You could open them in excel (as a new workbook), then move those columns of
data to anywhere you wanted.

 

[Daniel M]

Yes, I know i can bring it into excel and then manipulate it. However what i
would like to do is to have it do it automatically.

The data is something along the lines of...

part,description,count,refdes
a, part a, 1, p1

and so on.

 

[Bob Phillips]

Turn the macro recorder on, step through the process of importing the file
and manipulating the data, and you have your automation.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Yes, I know i can bring it into excel and then manipulate it. However what i
would like to do is to have it do it automatically.

The data is something along the lines of...

part,description,count,refdes
a, part a, 1, p1

and so on.

You could open them in excel (as a new workbook), then move those

columns

of
data to anywhere you wanted.

for.

the

all

i

match

up

didnt