filePro out to an existing Excel file

[Aljex Software]

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
>