>I've tested using your example but it gives me:
>
>Variable 'XLHTML' not found.
>
>I'm using Ms Excel 2000. Thanks.
It's a VBA constant with value 44. You could :
#define xlHTML 44
or directly use the value 44.
All constants for Excel are in files section. This constant isn't listed there because was introduced with Excel2000. For new constants to find value :
*!* If you cannot download wc0993.exe from microsoft site or UT files section
*!* xlConstants can be found by :
*!* -Open Excel
*!* -Select tools\macro\VB editor
*!* -Press F2 to bring up "Object browser"
*!* -Find needed xlConstant type ie:xlChartType
*!* -On right window click needed Constant ie: xl3DArea
*!* -Below the window constant value is displayed
Cetin