filePro out to an existing Excel file

[Rick Hane]

There is a way to do this in WIndows env.; however, I don't know about *nix.

We transfer data both ways from MSSQL and fp every day (using Excel's ODBC). 
  We use dif file format but I hear that csv also works well.  I don't have 
the worksheet load the the dif file automatically because I have been to 
busy (and lazy) to write the macro.  In Lotus I could have done it in 5 
seconds but alas I have not taken the time to learn VB or VBA.

A thought, could you use fpODBC to bridge fp and the Excel worksheet?

Thank you,
Rick Hane
Yore Software
Email: yoresoft at hotmail.com
Deluxe Stitcher Company Inc.
Url:www.deluxestitcher.com
Email: rhane at deluxestitcher.com

>From: Harwyn Berens <hlb at pop3.wmis.net>
>To: filePro <filepro-list at lists.celestial.com>
>Subject: filePro out to an existing Excel file
>Date: Fri, 27 Feb 2004 15:11:00 -0500
>
>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
>
>
>_______________________________________________
>Filepro-list mailing list
>Filepro-list at lists.celestial.com
>http://mailman.celestial.com/mailman/listinfo/filepro-list

_________________________________________________________________
Watch high-quality video with fast playback at MSN Video. Free! 
http://click.atdmt.com/AVE/go/onm00200365ave/direct/01/