View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
Daniel M[_2_] Daniel M[_2_] is offline
external usenet poster
 
Posts: 12
Default help with templete

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" wrote in message
...
You could open them in excel (as a new workbook), then move those columns

of
data to anywhere you wanted.



Daniel M wrote:

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.


--

Dave Peterson