MrExcel Publishing
Your One Stop for Excel Tips & Solutions

numerical values for excel file types


Posted by Bryce Winter on December 28, 2001 11:40 AM

I need to find out what the numerical value of the xlHTML file type is. Does anyone know where I might be able to find this, or have any ideas about how I might find it?


Posted by Dank on December 28, 2001 12:05 PM

You can find the values of any constants by using the object browswer in the VB editor. Open the VB editor and hit F2. Type the name of the constant in the textbox at the top. From there you'll see the value of xlHTML has a decimal value of 44.

Regards,
Daniel.