Subfiles to Excel. More info.

[Seamus at partage.org]

--- SLK (Symbolic link) FORMAT ---
Excel can read the .slk file format as well.
It's the format used by the Mother of all Spreadsheets: Visicalc.
My brother in law always makes data files in slk format
(he grew up with them) but I have never used them as CSV has done everthing
I ever needed.

One thing to avoid when creating headers for data files in .SLK format ...
The first line, (= top row = column header)   should never start with the
letters "ID" such as in "ID-CLIENT".
When Excel opens a file that starts with "ID" it thinks it is dealing with a
.slk file and then can't read the rest of the data and sends back a message
saying there is a problem with the .slk file.
Replace "ID-CLIENT" with "CLIENT-ID" and that will work fine.

--- EXCEL FORMULA IN A SUBFILE DATA FIELD ----
Another interesting thing, probably quite useless, but you never know ...
You can get your Quiz to write an Excel formula in a data field.
E.g.

DEF PACKET CHAR * 240  =                    &,
  PACK  (PART-NAME                  + ";" + &,
     "=[difference.xls]Weekly!$B$4" + ";" + &,
     ASC(PART-PRICE,10[1:8])        + "." + &,
     ASC(PART-PRICE,10[9:2]) )
When Excel reads the data it will interpret the formula.

Or you can switch to L1C1 reference in the Options and use
=[difference.xls]Weekly!L4C2
or even
=LC(1)*[difference.xls]Weekly!L3C2
But generally it is more efficient to do all the calculations on the main
machine before transferring the subfile.

Seamus