![]() |
Macro Question
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. |
All times are GMT +1. The time now is 12:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com