Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HTML parsing with VBA
hello, I am trying to modify a recorded macro that replaces an HTML tag
with "". The macro I recorded is below. I want to replace the 7 in the Rows parameter with a counter, i, and use a For ..Next statement to loop through each row in the worksheet. However, this is giving me an app error. Does anyone know how I can do this? Thanks. ------ Original Macro ------- Sub CleanHTML() ' CleanHTML Macro ' Macro recorded 4/17/2006 by Mark Oium Rows("7:7").Select Selection.Replace What:="<*", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False End Sub ------ Modified Macro ------ Sub CleanHTML() Dim i as Integer 'CleanHTML Macro 'Macro recorded 4/17/2006 by Mark Oium For i = 1 To 1396 Rows("i:i").Select Selection.Replace What:="<*", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Next i End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
HTML parsing with VBA
For i = 1 To 1396 Rows("i:i").Select Selection.Replace What:="<*", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Next i End Sub For i = 1 To 1396 Rows(i).Replace What:= etc. Next i -- Dick Kusleika MS MVP - Excel www.dailydoseofexcel.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
HTML parsing with VBA
Thhanks Dick. That worked without any errors. But now it seems as
though the macro is not searching the entire row. The file has 90 columns and up to 1400 rows. Many of the cells contain several HTML tags and not all are being replaced with "". Also, some tags are preceded by a few spaces, these are not being replaced either. Do you have any advice? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from processing HTML? IE paste raw html. | Excel Discussion (Misc queries) | |||
Parsing | Excel Discussion (Misc queries) | |||
Excel & HTML Parsing | Excel Discussion (Misc queries) | |||
parsing HTML table into excel. How? | Excel Programming | |||
Parsing Data From HTML Source into Excel using VBA | Excel Programming |