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, 10 views)
File Type: doc html data output file.doc (21.5 KB, 10 views)
Reply With Quote
Reply



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 12:08 PM.


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