filePro out to an existing Excel file

[Mike Rathburn]

If it's Excel 2002+, then look at exporting in XML format with metadata.

-Mike R.

|-----Original Message-----
|From: filepro-list-bounces at lists.celestial.com
|[mailto:filepro-list-bounces at lists.celestial.com]On Behalf Of Aljex
|Software
|Sent: Friday, February 27, 2004 8:38 PM
|To: Jeff Harrison; 'Harwyn Berens'; filePro
|Subject: Re: filePro out to an existing Excel file
|
|
|We just started to research this also, we want to open our 
|data in an excel
|file and use a macro with graphs.
|
|Any input is appreciated.
|
|
|----- Original Message -----
|From: "Jeff Harrison" <Jeff.Harrison at Epixweb.com>
|To: "'Harwyn Berens'" <hlb at pop3.wmis.net>; "filePro"
|<filepro-list at lists.celestial.com>
|Sent: Friday, February 27, 2004 8:12 PM
|Subject: RE: filePro out to an existing Excel file
|
|
|> Harwyn Berens wrote:
|> >
|> > Hello all:
|> > I'm wondering if it's possible to get a filepro output
|> > form's output into
|> > an already existing Excel file.  I have an estimating program
|> > that we use
|> > and to date it has proved to be a nice format for the final
|> > product for
|> > most of our customers.
|> > One of our largest customers is now strongly pushing
|> > for the output format
|> > to be in Excel exactly as their form is designed in Excel.
|> > They now  send
|> > us a Request for Quote in an .xls format as an e-mail
|> > attachment.  It has
|> > all the pertinent information on the .xls file with the
|> > exception of the
|> > estimated costs which we're expected to estimate, fill in the
|> > appropriate
|> > blanks and transmit back to them.  We now estimate using
|> > filePro and from
|> > the fP output form, we manually enter the estimated cost
|> > numbers onto the
|> > appropriate Excel Request for Quote .xls file and e-mail it
|> > back to the
|> > customer.
|> > I'm using Windows 98 with fP 4.05.08.  Is there an
|> > (here goes nothing)
|> > easy way to do this?  I realize this last question differs
|> > significantly
|> > from my opening one.  I currently produce the fP quote output
|> > from within
|> > the estimating input table via the FORM command.  Thanks.
|> >
|> > Harwyn Berens,
|> > Holland, MI
|> >
|>
|> I don't know about the Excel format, but I'm sure it would 
|be much easier
|to
|> just export to a csv file - excel can read those 
|automaticaly.  If that is
|> not good enough you should be able to create a macro in 
|excel that will
|read
|> the csv (or other formatted file that filepro can create 
|easily) into an
|> existing spreadsheet.
|>
|> Good Luck.
|>
|> Jeff Harrison
|> jeff.harrison at epixweb.com
|>
|> Author of JHExport and JHImport - The fastest and easiest 
|ways to generate
|> code for filepro exports and imports.  Demos available upon request.
|> _______________________________________________
|> Filepro-list mailing list
|> Filepro-list at lists.celestial.com
|> http://mailman.celestial.com/mailman/listinfo/filepro-list
|>
|
|_______________________________________________
|Filepro-list mailing list
|Filepro-list at lists.celestial.com
|http://mailman.celestial.com/mailman/listinfo/filepro-list
|