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
Bookmarks