Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open HTML as Text
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open HTML file, but doesn't copy correctly | Excel Worksheet Functions | |||
Open HTML in Excel | Excel Discussion (Misc queries) | |||
How to open an html file from within a macro | Excel Programming | |||
Open Html file i Excel | Excel Programming | |||
Open file saved in HTML format | Excel Programming |