>>Look at the help in VFP about CREATEOBJECT(). It actually shows you how to
>>create an instance of excel. Once you have the object reference to excel,
>>you can do anything you want with it.
>
>One thing I couldn't find: how do I run an excel macro? Can't figure out
>the hierarchy, syntax or whatever is necessary.
>(VFP 5.0 and Office 97)
You could record the macro and edit/copy the code into your VFP application and do all the commands through OLE.
Wayne
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown