The reference I used was Excel's Help from within the Visual Basic Editor.
There is a topic "Microsoft Excel Constants" it lists groups, or families of
constants that can be expanded to see all the members. Turns out it looks
like what we used is technically "xlCurrentPlatformText" (value -4158) and
part of the xlFileFormat family. I was actually unable to find the specific
"xlText" in any of the lists I looked through. But what I did was use the
Immediate window in the VB Editor to simply tell it to
Print xlText
and it returned -4158
Or bookmark this page:
http://msdn.microsoft.com/library/de...HV01049962.asp

If you don't have Excel available to use as a reference source like that,
you can always ask here in the forums, just tell people what you're trying to
do and that you need the numeric value for a parameter rather than just the
parameter name and I'm sure someone will help you out.
"jim sturtz" wrote:

good point.

i tried looking around for a source on the -4158 (or even a list of all the
properties/events/methods) of the excel object and didnt find a concise
source.

could you point me to some references you are using.

thanks.

jim