View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default help with templete

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