#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
carl
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Quick Macro question - How to delete two rows then skip one - and repeat David Smithz Excel Discussion (Misc queries) 3 March 3rd 06 02:58 PM
Excel Macro Question billrl34 Excel Worksheet Functions 1 December 19th 05 10:38 PM
using a macro question revisited Adam Kroger Excel Discussion (Misc queries) 4 December 16th 05 03:37 PM
Excel Macro Question about Conditional Formatting David Britton via OfficeKB.com New Users to Excel 3 February 10th 05 02:23 PM
Attn: Dave P. Question re Pix Calls via Macro DocuMike Excel Discussion (Misc queries) 1 January 10th 05 01:38 AM


All times are GMT +1. The time now is 10:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"