For each loop issue

I am trying to say the following

for each "value" in "this array"
do this
next for

I am unsure how to select a single value out of an array using a for each loop.

Note:
the array holds a group of string values

Sample data:
href=, scr=,...

This what you mean?

Please Login or Register  to view this content.

Is it possible to use this type of loop for a multi-dim array?

for each x in array(a:a, b:b, c:c...)
do this
next x

If you're using ranges:

Please Login or Register  to view this content.

What is your array exactly? An explanation of what it is you're trying to accomplish might also be helpful.

Here is the code I am currently using

Please Login or Register  to view this content.

My problem is with this section

Please Login or Register  to view this content.

I am looking to use the first value as the folder name from outlook and the second name in place of "Test" as the download location. I can do this with a for loop and copy of the values in a sheet, but I would like this all hidden in a macro that I can lock and prevent changes by those pesky people who want to get into everything, hense the desire for a for each loop with a multi-dim array.

NOTE: The sample above only has one run worth of values within it.

Here are some ways to manipulate arrays. Obviously you can use something other than "Activecell.offset" to determine the value, I just used this example so as to, hopefully, be easier to understand what the macro is doing.

Please Login or Register  to view this content.