>i downloaded the xl97cons.h file. Is this the one?
>

Yep, must be...

>
>The variable is listed as:
>
>xlDown -4121
>
>How do I write it into my code?

You don't. What you do is put the following declaration in your code somewhere (a form init, a button click, wherever you need it):

#INCLUDE xl97cons.h

Then all the Excel constants will be automatically found...