David,
You've to define them. The easiest way is to create a header file using Object Browser (VFP7 and later) or GetConstants utility from
http://west-wind.com/Webtools.asp and include header file in your Excel automation programs.
>Hi, for the sample code below:
>
>#define xlShiftUp -4162
>oApp = GETOBJECT('', "Excel.Application")
>oApp.Workbooks.Open('somefile.xls')
>oApp.Rows("1:1").Delete(xlShiftUp)
>....
>
>How can I reference the xlShiftUp constant without defining it myself?
>For example, oApp.xlShiftUp does not work...
>
--sb--