I am trying to open a HTML file as text in Excel VBA to programmatically add
some tags.

I tried to use this command:

Workbooks.OpenText Filename:=sInputPathFile, Origin:=xlWindows _
, StartRow:=1, DataType:=xlFixedWidth, FieldInfo:=Array(Array(0, 1),
Array(200, 1))
Columns("A:A").EntireColumn.AutoFit

But it still opens the file as HTML. If I can the extension to .txt it
opens fine.

Does anyone know a method to open it as text.

Thanks,

MEG