help with templete

D

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.
[email protected]
 
D

Dave Peterson

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

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.
 
B

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)

Daniel M said:
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.


Dave Peterson said:
You could open them in excel (as a new workbook), then move those
Click to expand...
columns
of
data to anywhere you wanted.
Click to expand...
for.
the
Click to expand...
all
i
Click to expand...
match
up
Click to expand...
didnt
Click to expand...
 
Top