Menu

HTML parsing with VBA

Search this Thread

Previous Post

Next Post

#4

Report Post

Posted to microsoft.public.excel.programming

Dick Kusleika[_4_] Dick Kusleika[_4_] is offline

Dick Kusleika[_4_] is offline

external usenet poster

Posts: 595

Default

HTML parsing with VBA

wrote:
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.

This worked for me

Sheet1.Rows("1:52").Replace "<*", "", xlPart, xlByRows, False, , False,
False

replace the 52 with whichever number of rows you want.

I don't know why it wouldn't replace all the tags. Maybe you can post an
example of one it's not replacing. It won't replace spaces unless you tell
it to. You could repeat the above line three times to catch when there are
two preceding spaces.

Sheet1.Rows("1:52").Replace " <*", "", xlPart, xlByRows, False, , False,
False
Sheet1.Rows("1:52").Replace " <*", "", xlPart, xlByRows, False, , False,
False
Sheet1.Rows("1:52").Replace "<*", "", xlPart, xlByRows, False, , False,
False

The first one looks for two spaces, then one, then none.

--
Dick Kusleika
MS MVP - Excel
www.dailydoseofexcel.com

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Stop excel from processing HTML? IE paste raw html.	nick	Excel Discussion (Misc queries)	2	April 21st 23 05:12 PM
Parsing	Saxman[_2_]	Excel Discussion (Misc queries)	3	July 30th 07 04:36 PM
Excel & HTML Parsing	Porphyria	Excel Discussion (Misc queries)	4	June 24th 06 12:18 AM
parsing HTML table into excel. How?	Dan[_38_]	Excel Programming	6	July 11th 04 10:19 AM
Parsing Data From HTML Source into Excel using VBA	Peter Dickson	Excel Programming	1	July 9th 03 11:00 PM

All times are GMT +1. The time now is 06:02 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement