Hi,
I have a requirement to modify HTM file properties in bulk. I have currently around 110 files in .html format.
They all have iteration of a shape used with defined custom properties.
-------
<DIV tabIndex=-1 id=P011_012_013_014 class=hsc.shape.1
style="FONT-SIZE: 0px; TEXT-DECORATION: none; HEIGHT: 75px; FONT-FAMILY: Arial; WIDTH: 75px; POSITION: absolute; FONT-WEIGHT: 400; FONT-STYLE: normal; LEFT: 560px; TOP: 197px; BEHAVIOR: url(#HSCShapeLinkBehavior) url(#HDXVectorFactory#shapelink)"
hdxproperties="fillColorBlink:False;Height:75;lineColorBlink:False;Width:75;"
value = "1" src = ".\A3F35_files\Mot.sha" parameters =
"Point?NameOne:Test;Parameter?ParamOne:PV;Parameter;Value?DataSourceOne:X1;Point?NameTwo:Test1;Parameter?ParamTwo:PV;Value?DataSourceTwo:X2;
linkType = "embedded" globalscripts = "" styleClass = "">
------
Basically I want to go through all files in a local folder and Modify "Paramone"or "Paramtwo" value strings based on different Datasource options.
I am very new to Excel VBA macros and looking for some directions on how I can import htm data from multiple files and Parse it in Excel, modify the values (if Parsed data is split into Columns, can run analysis and update values) and Save these updates in source Html files.
Regards,
Jawad
Bookmarks