Hi,

thanks for responding... I will keep your note handy for when I get into Excel.

Albert Gostick

>>Hi all,
>>
>>I could go looking around but just wondered if anyone has released classes to automate Word and Excel? I have the book "Microsoft Office Automation with Visual Foxpro" and its all good stuff - but I think I could sell a client on doing some automation stuff if I did not have to spend time first writing a generic Word and Excel class to do stuff like opening each of these, opening/closing documents and all that housekeeping kind of stuff.
>>
>>Anything out there either free or commercial?
>
>For excel you can check Rep2excel and CodeRep downloads here.
>They both have my excel automation class source code.
>
>What I have done was make flat excel class that automates most of basic
>operations completely hiding excel object model/complexity.
>
>You are basically able to manipulate excel file as 3d array
>like;
>
>oXL.make_cell(nSheet,nRow,nCol,'Hello There')
>
>and higher level method calls
>(I forgot exact method names but something to this effects)
>
>oXL.WriteTable(...)
>oXL.WriteArray(...)
>oXL.DrawLine(..)
>oXL.DrawBox(..)
>etc
>
>HTH
>Sergio