View Single Post
 
Old 12-02-2021, 09:14 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 Do Loop

Hello

Thanks for replying. The macro can be real simple if there is number just appear 1 time in the whole beginning and ending of html tag. There are more than 1 numbers in the body of beginning and ending of the html tag, so the whatever is in title and /title has to be attached to those number to know as to which number belong to which records. Attached is the output file.

input file can be found below link it only 3 records but 48 pages of html data in word.

input data 1202.doc - Google Docs

also one of the things that complicates the macro, that sometime numbers have 3 format to extract as below.

(###) ###-####
(###)###-####
###-###-####

As you said there is a better way to do it, if it can be done without opening 3 windows that would be great.

Thanks a lot!!
Attached Files
File Type: doc output data 1202.doc (22.0 KB, 12 views)
Reply With Quote