I am new to the loop function/command in VBA. I was curious if VBA is capable of writing a macro to find within its own macro certain data like a "MMDDYY" and replace is with other data you give it from a list then run the macro and loop until the list of data you give it is exhausted.

For example, In the follow code I want to replace "MMDDYY" with the number one item on the list seen below then run the code but once the macro has ran this set of code loop again replacing the "MMDDYY" again with the second number on the list looping until the list is exhausted.
1) 010113
2) 010213
3) 010313
4) ...
5) and so on.

Workbooks.OpenText Filename:= _
        "I:\ACCOUNTING\GL Oracle\complete\GeneralLedgerFile_MMDDYY.txt", Origin:=437 _
        , StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _
        ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False, Comma:=False _
        , Space:=False, Other:=False, FieldInfo:=Array(Array(1, 1), Array(2, 1)), _
        TrailingMinusNumbers:=True