filePro out to an existing Excel file

[Mike Schwartz-PC Support & Services]

> Hi,
> How do you make the export put the filePro fields go into the right cells
> on
> your spreadsheet... I would love to see the processing table. Thanks.
> Come on the room and tell us or show us, also. Thanks.
> 
> John

	There's no magic here.  I usually don't write a cell-by-cell export.

	Here's an over-simplified example.  If your customer sends you a
quote sheet like:

Part# QtyRequested QuotedPrice

12345     3
23456     5
78901     10

I would import the columns I need into filePro, do the filePro calcs, then
export a .TXT or .CSV file that looks like:

12345     10.00
23456     20.00
78901     30.00   

The user can open up this spreadsheet, cut the values out of the price
column, then paste them into the original Excel sheet as values.  I believe
that's what the original requestor wanted to do.

I export the part number column again just as a double check, so that a user
doesn't paste an incorrect column of quotes into the wrong sheet.  I also
train the users cross-check the page in several other ways, such as by
examining the bottom of the spreadsheet to make sure the columns come out
evenly and to look at the summary totals at the bottom, to make sure the
final total matches the filePro quote total. 

The reason I don't just export the whole sheet is because there are
underlying math formulas as well as special formatting within the original
order sheet that a .TXT or .CSV file can't handle.  This special formatting
must be maintained so that when my customer returns this sheet to their
customer, their customer can read the results back into their computer
systems correctly.

Of course, .DIF files allow me to get a little more creative with the ways I
export things.

This beats entering all the data into the original Excel sheet by hand.

Mike