opening and amending an excel spreadsheet from filePro

[Bill Campbell]

On Thu, Apr 22, 2010, John Esak wrote:
>I agree with Ken's suggestion.  But, just curious... What you are doing now
>sounds like enough. What's wrong with it?  I am not sure, but I think you
>can even name the .csv back to .xls... And it gets read in.  Maybe not, but
>the .csv could automatically be read into Excel and then written out as a
>.xls and you could send that one?  No?  It's a long way around the horn, but
>it would work wouldn't it? That is if you dumping their .xls into a .csv....
>Reading it in, processing it, then writing back out a new .csv. The last
>step would be to read in that .csv into Excel and write it out in its native
>format?  Macros could do all this pretty easily, right?  I know we did
>miracles with word documents and the -m flag along with some carefully
>recorded macros.  Assuming Excel's macro recorder is the same as the one in
>Word, which it must be.

Macros can do all sorts of things.  Back in 1981 when I was
managing a Radio Shack X-department in D.C. I did my daily
reports by first putting the numbers in a Visicalc spread sheet,
the pulling that into a ScripSit document and hitting one
function key that ran a series of macros that formatted them to
print on Radio Shack's Daily Report form.  My District Managers
were amazed to see typed daily reports :-).

Bill
-- 
INTERNET:   bill at celestial.com  Bill Campbell; Celestial Software LLC
URL: http://www.celestial.com/  PO Box 820; 6641 E. Mercer Way
Voice:          (206) 236-1676  Mercer Island, WA 98040-0820
Fax:            (206) 232-9186  Skype: jwccsllc (206) 855-5792

We shouldn't elect a President;  we should elect a magician.
    Will Rogers