Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Word VBA

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 03-07-2019, 12:17 PM
donlincolnmsof donlincolnmsof is offline Windows 7 64bit Office 2003
Novice
 
Join Date: Oct 2011
Posts: 20
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, 0 views)
File Type: doc html data output file.doc (21.5 KB, 0 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extract data from two worksheets into one Rudi Excel 4 10-18-2018 06:47 PM
Need help to extract specific data from text file using vba victor92 Excel Programming 0 12-01-2017 12:53 AM
Extract Data From Text file based on Pattern PRA007 Word VBA 13 11-01-2015 11:20 PM
Macro to highlight repeated words in word file and extract into excel file aabri Word VBA 1 06-14-2015 07:20 AM
How to Extract key data from word iliauk Word 3 11-08-2013 04:37 PM


All times are GMT -7. The time now is 05:38 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft