Search local .html file for certain values and store to each to variables.

sparky5106 · #1 03-28-2019, 12:50 PM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Testing multiple values of two independant variables and charting results	sgcannon	Excel	0	10-20-2015 10:10 AM
Search and replace/insert HTML code into Master File using tags	dave8555	Excel	2	02-23-2014 03:51 PM
Same values of variables in word add-in are being shared across multiple document	naq.abbas@gmail.com	Word	0	01-13-2014 10:41 AM
add values from different variables with pivot table	andrei	Excel	2	01-19-2012 08:45 AM
parse, store and email a .tmp file from wordpad?	scadaman29325	Office	0	09-28-2010 04:56 PM