Const values for late binding declarations

[keith_shoaf]

Hello Everyone! I am looking for a complete list, if it exists, of all MS Office application function’s constants values. I want to be able to use late binding, but in order to do so, I need to declare all application specific functions as a Const like in the example below.

1. Const xlTemplate As Long = 17
2. Const xlContinuous As Long = 1
3. Const xlThin As Long = 2

and also like: xlWB.Selection.PasteSpecial Paste:=-4163, Operation:=-4142

I need to use late binding because within my organization, some people have Office 2010, and some have Office 2013. So if I use early binding when coding in Office 2013, folks using Office 2010 cannot execute the mirco-app due to libraries. Any help on where I can find the proper values for all functions is GREATLY APPRECIATED!

 

[shg]

There's a list of 4000-odd at https://app.box.com/s/roez5ssfcjok48sgd74bl9otuskye8x5

 

[keith_shoaf]

THANK YOU shg!! Much appreciated!

 

[shg]

You're welcome.