>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
When copying from a macro, you must ignore the titles of the parameters
Try this, it works fine:
myobj_excel.Workbooks(1).Names.Add("testing", "=sheet1!R1C1:R3C3")
Hope this helps
Saludos,
A.G.P.
---------