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
-Randy Robinson
Para Systems, Inc.