filePro out to an existing Excel file

[GCC Consulting]

> 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.
> 
> 
You would need to use "export word"

   if:
 Then: export WORD com=c:\temp\salon.csv  (

The above creates a CSV file which can be opened directly into Excel.  The
salon.csv file is created on the local PC's temp directory.

This is run from a script which opens the file after it is created.

You can create a macro to reformat the information and then start the graph.

Just remember that if you want headers, you must first output the header then
loop back and start you data output.

  If: @rs = "1"
 then: GOSUB doheader
  if:
 then:com(1)=1;com(2)=2;l etc;
  if:
 then:END 
doheader:if:
       then: com(1)="header 1";co(2)="header 2"; etc;write; RETURN

The menu script for this looks like this:
@\fp\rreport company -F salon_csv -a -u
@start excel c:\temp\salon.csv

It is fast and simple.

Richard Kreiss
GCC Consulting