View Single Post
 
Old 03-28-2019, 12:50 PM
sparky5106 sparky5106 is offline Windows 10 Office 2019
Novice
 
Join Date: Mar 2019
Posts: 1
sparky5106 is on a distinguished road
Default Search local .html file for certain values and store to each to variables.

I am trying to automate the majority of our reporting through a userform and the last part I want to do is be able to scan a local .HTML file for a certain class? and store the values into variables from which I can populate a table. I'm not really sure where to start as my VBA knowledge is very limited and any help would be appreciated. Attached is the section of .HTML file that I would need to pull out and it occurs 6-8 times for which I would need all of the values.
Attached Images
File Type: jpg localhtml.JPG (57.1 KB, 11 views)
Reply With Quote