There are some commands I don't know how to handle using OLE automation in Excel.

Recording a macro is a fast way to get syntax, but here's what I get when I name a range:

ActiveWorkbook.Names.Add Name:="testing", RefersToR1C1:="=Sheet1!R1C1:R1C3"

The "Add Name" includes a space and FoxPro doesn't like the space. Maybe I'm overlooking something simple, but how do you send that command from FoxPro?

Randy Robinson