Frank,
I think you directed him to a long and winded path:) He's asking automating with VFP. Office installation CD has necessary VBA help files.
Cetin
>This might assist:
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_wrcore/html/wrconexcelobjectmodeloverview.asp>
>>I just need a small code sample to do the following from VFP program: To create an Excel
>>file with a single sheet, fill cells with some data from my dbf, apply colors and fonts
>>to cells. Other features of Excel (like setting formulas) are not required. I do not
>>want to use the command COPY TO .. TYPE XLS. Can anybody help me? Thanks in advance.