filePro out to an existing Excel file

[Mike Schwartz-PC Support & Services]

> From: Harwyn Berens <hlb at pop3.wmis.net>

> 	I'm wondering if it's possible to get a filepro output form's output
> into an already existing Excel file.

	I've done a *lot* of this work with spreadsheets.  The technique
that you should use will vary, depending on what the original spreadsheet
looks like and exactly what data has to be posted into it.

	 If the incoming Excel sheets are standardized, it might be easiest
to create a filePro file that exactly matches the layout of the Excel file,
then import the spreadsheet, work with it in filePro, then export the entire
sheet.  (I only mention this, because I had to spend a couple of hours
yesterday modifying some import and export functions for one of my customers
because *their* customer changed the layout of the incoming Excel sheet.)

	Sometimes I just export a small .CSV or .DIF file out of filePro and
cut and paste columns into the original sheet.

	fpODBC may be the ultimate method, if you have very complex Excel
spreadsheets with lots of interactive formulas in them.

	To answer your question generically, because I don't have any of
your specific spreadsheets to look at and I don't know the layout of your
existing filePro files, I've never failed to find some kind of solution that
combines filePro with Excel in order to save my customers a big chunk of the
time that they would otherwise have to spend doing manual data entry.