The simplest way to find out what these values are is to open the
immediate

Or just set a reference to the Office typelib and use the constant name.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"RB Smissaert" wrote in message
...
Things like msoXXX and XlXXX are MS Office and Excel constants
respectively and
when you use these in VB6 you need the actual value.
The simplest way to find out what these values are is to open the
immediate window in
the VBE by pressing Ctrl + G and then type in ? followed by the constant.
Then press the return key. There you will see the actual value.

RBS


"avi" wrote in message
...
It works!!!!

Thanks
Avi