>>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...
Almost forgot: add the xl97cons.h as a Text File to your project.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.