C
carl
I have some data in ColA like this:
[Application]
Name=StatsWatch.exe
[DataWindow]
20066712812133=4
[20066712812133]
Sort=
SortCount=1
FilterNegation=0
Filter=
FilterCondition=
FilterCount=1
FilterConditionCount=1
HiddenColumns=
HiddenColumnsCount=1
ColumnOptionsCount=3
WindowTitle=Statistics Graph by Group: 21
WantedTotals=0
WantedList=GG;
WantedListCount=1
ActiveSelection=(GG,5,2,65535,0);(GG,5,8,32768,0);
ActiveSelectionCount=1
ShowLegend=0
ShowTimeLabels=1
TimeLabelDensity=2
ShowDataLabels=1
DataLabelDensity=2
GridBkgColor=0
GridPenColor=32768
GridCellSize=20
XAxisUpdateStep=5
GraphType=1
ShowCommonScale=1
ShowThreshold=0
ThresholdValue=0
ThresholdStaysOnTop=0
ShowFixedScale=0
FixedScaleValue=0
I also have a target list like this in a different worksheet:
AB
SD
QF
In these 2 lines from above:
WantedList=GG;
ActiveSelection=(GG,5,2,65535,0);(GG,5,8,32768,0);
Is it possible to do the following:
From ColA above, in these 2 lines "WantedList=GG" and
"ActiveSelection=(GG,5,2,65535,0);(GG,5,8,32768,0);"
Replace Value GG with the first value in the Target List (AB), save an new
file with this change as text, with a .CFG file extension. Then repeat for
the next value in the Target List (SD) and continue to do this until till the
end of the Target List ?
Thank you in advance.
[Application]
Name=StatsWatch.exe
[DataWindow]
20066712812133=4
[20066712812133]
Sort=
SortCount=1
FilterNegation=0
Filter=
FilterCondition=
FilterCount=1
FilterConditionCount=1
HiddenColumns=
HiddenColumnsCount=1
ColumnOptionsCount=3
WindowTitle=Statistics Graph by Group: 21
WantedTotals=0
WantedList=GG;
WantedListCount=1
ActiveSelection=(GG,5,2,65535,0);(GG,5,8,32768,0);
ActiveSelectionCount=1
ShowLegend=0
ShowTimeLabels=1
TimeLabelDensity=2
ShowDataLabels=1
DataLabelDensity=2
GridBkgColor=0
GridPenColor=32768
GridCellSize=20
XAxisUpdateStep=5
GraphType=1
ShowCommonScale=1
ShowThreshold=0
ThresholdValue=0
ThresholdStaysOnTop=0
ShowFixedScale=0
FixedScaleValue=0
I also have a target list like this in a different worksheet:
AB
SD
QF
In these 2 lines from above:
WantedList=GG;
ActiveSelection=(GG,5,2,65535,0);(GG,5,8,32768,0);
Is it possible to do the following:
From ColA above, in these 2 lines "WantedList=GG" and
"ActiveSelection=(GG,5,2,65535,0);(GG,5,8,32768,0);"
Replace Value GG with the first value in the Target List (AB), save an new
file with this change as text, with a .CFG file extension. Then repeat for
the next value in the Target List (SD) and continue to do this until till the
end of the Target List ?
Thank you in advance.