Download #
9498 includes constants for Excel 97. If the option you are looking for isn't anything which appears only in a more recent version, this download should help.
Extract the .h file, and use the #INCLUDE command in the program where you need the constant. See #INCLUDE and #DEFINE in the help, if you don't know what this is about.
>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...
>
>Thanks,
>David
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
