View Single Post
 
Old 03-07-2019, 12:17 PM
donlincolnmsof donlincolnmsof is offline Windows 7 64bit Office 2003
Advanced Beginner
 
Join Date: Oct 2011
Posts: 36
donlincolnmsof is on a distinguished road
Default Extract data from HTML File.

Hello

I’m looking for a macro that will extract the data from an HTML file.

The file “ html data.DOC” contains Raw data
The data file is a bit large and can be found at the following link
https://1drv.ms/w/s!AskgROwjljL3im2b_LDHF6T2Wvfe

The file “html data output file.DOC “ is the output that I’m looking for.

The file “html data macro code file.DOC” contains the macro data

I wrote the macro to extract the data, it somewhat work, but it fails if one of the data field is not found and it aborts.

Below are the keys that I search for.

<!DOCTYPE html>
"utf-8"/><title>
|
For sale:
ds-estimate-value">

Any help would be greatly appreciated.

Thanks.
Attached Files
File Type: doc html data macro code file.doc (25.5 KB, 8 views)
File Type: doc html data output file.doc (21.5 KB, 8 views)
Reply With Quote