Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 Can a macro do the following: Looking at these two lines from ColA above, WantedList=GG; ActiveSelection=(GG,5,2,65535,0);(GG,5,8,32768,0); Replace Value GG with the first value in the Target List (AB), save a new text file named (AB).txt, then add the file extension .CFG ? 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Quick Macro question - How to delete two rows then skip one - and repeat | Excel Discussion (Misc queries) | |||
Excel Macro Question | Excel Worksheet Functions | |||
using a macro question revisited | Excel Discussion (Misc queries) | |||
Excel Macro Question about Conditional Formatting | New Users to Excel | |||
Attn: Dave P. Question re Pix Calls via Macro | Excel Discussion (Misc queries) |