Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-07-2019, 12:17 PM
donlincolnmsof donlincolnmsof is offline Extract data from HTML File. Windows 7 64bit Extract data from HTML File. Office 2003
Advanced Beginner
Extract data from HTML File.
 
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
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 HTML File. 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
Extract data from HTML File. How to Extract key data from word iliauk Word 3 11-08-2013 04:37 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:21 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft