Open HTML file in VBA using workbooks.open

[DartGuru]

If I open an html file from VBA, for example.:-
Set WB = Workbooks.Open(sFullFile, 0, True) ' 0=do not updatelinks,
true=readonly

a new workbook opens with the html file in it as expected, but some
text is automatically converted to date format.
For example 03-4703 becomes 01/03/4703 or 03-Mar.

Can I open the html file without it performing these automatic
conversions?

TIA

 

[DartGuru]

If I open an html file from VBA, for example.:-
Set WB = Workbooks.Open(sFullFile, 0, True) ' 0=do not updatelinks,
true=readonly

a new workbook opens with the html file in it as expected, but some
text is automatically converted to date format.
For example 03-4703 becomes 01/03/4703 or 03-Mar.

Can I open the html file without it performing these automatic
conversions?

TIA

I know it's bad form to bump your own post, but I've still not figured
out how to so this.
Anyone ?

 

[dartguru]

bump