Re: help with templete

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Daniel M (danielmm_at_earthlink.net)
Date: 05/22/04


Date: Sat, 22 May 2004 06:02:48 GMT

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" <ec35720@msn.com> wrote in message
news:40AEAA2A.59991437@msn.com...
> 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.
> > dtm28@earthlink.net
>
> --
>
> Dave Peterson
> ec35720@msn.com



Relevant Pages

  • Re: new document type
    ... If you want New Document to open Excel in a particular document library, ... just specify Excel as the default template for that document library. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: help with templete
    ... I know i can bring it into excel and then manipulate it. ... I have a cad package ... >> that i can generate a bill of materials for and specify a template for. ...
    (microsoft.public.excel.misc)
  • Re: help with templete
    ... > that i can generate a bill of materials for and specify a template for. ... > can generate out of the cad package are text delimited files. ... > a way to import this data into excel? ...
    (microsoft.public.excel.programming)
  • Re: help with templete
    ... > that i can generate a bill of materials for and specify a template for. ... > can generate out of the cad package are text delimited files. ... > a way to import this data into excel? ...
    (microsoft.public.excel.misc)
  • help with templete
    ... I have a project i am trying to do with a template. ... "column=count" or whatever the field in the cad package is. ... I would like to be able to specify columns in excel and have them match up ...
    (microsoft.public.excel.programming)