>How do I create a macro in Excel to run a program in VFP?
>Thanks
>Steve

Are you asking how to create a macro, or what the commands are to run VFP as an automation server. I've never created macros in Excel, so I can't help you there. If you want to use VFP as an automation server, you need to define a class as OLEPUBLIC in VFP. Then you instantiate it by saying:

ox = CreateObject("FOXOLE.MyClass")

See the "Creating Automation Servers" topic in the online help for details.