Re: help with templete

From: Bob Phillips (bob.phillips_at_notheretiscali.co.uk)
Date: 05/22/04 

Date: Sat, 22 May 2004 11:34:00 +0100

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" <danielmm@earthlink.net> wrote in message
news:c2Crc.4770$Tn6.3005@newsread1.news.pas.earthlink.net...
> 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: help with templete
    ... and manipulating the data, and you have your automation. ... I know i can bring it into excel and then manipulate it. ... >>> package did it unless it was something integrated into the package. ...
    (microsoft.public.excel.misc)
  • Re: Drop & Create Table - DTS Export to Excel
    ... Allan, ... That is to say that on the initial execution of the ... package, the data fell into place perfectly and as expected. ... if I open the Excel file and manualy delete all affected rows and ...
    (microsoft.public.sqlserver.dts)
  • Re: Table trouble (multi-page, multi-colour)
    ... I've tried Excel2LaTeX and LaTable, but none of those programs do the ... You could format the column separators in Excel, ... you could also type row colour codes (see the ... For this you could consider the geometry package; ...
    (comp.text.tex)
  • Re: Distributed Access references
    ... understand from trying to package an app and working w/ ... Although it appears that the excel does get packaged by ... So my app relies on the user having their own ... As for the other references I am not sure what to do? ...
    (microsoft.public.access.devtoolkits)
  • Re: I cant make hammock tasks work
    ... scheduelling package that computes the dates for you. ... costs and the costs will also be calculated, ... In Excel you can just start typing in numbers and away ...
    (microsoft.public.project)