>Hi, for the sample code below:
>
>oApp = GETOBJECT('', "Excel.Application")
>oApp.Workbooks.Open('somefile.xls')
>
> oApp.Rows("1:1").Delete(xlShiftUp) && delete fieldnames
If you need Excel constants in VFP, you might try file#
9498 in Downloads section.
Or, you can open Excel object in Object Browser in VFP, look up the constants values there, and use their values directly or declare constants in VFP yourself.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison