Excel Vba Loop List

[exc4libur]

Dear experts

I have a list of values in Column A that I want to loop through using this code and save as a text file.

I've managed to write the code below to run one value at a time and modifying it manually. So, I have to keep changing the "i.value = CE" and the "FileName", respectively everytime, which is madness when you have to do this more than 50 times.

I've attached a sample workbook with the module for testing.

Any help would be much appreciated
Thank you

Please Login or Register  to view this content.

[AB33]

The code does not appear to work. I do not think downloading a file is that simple, but if you want to loop through each cell in column A where the "CE" comes from column A while the file name comes from column B.

Please Login or Register  to view this content.

[exc4libur]

The code does not appear to work. I do not think downloading a file is that simple, but if you want to loop through each cell in column A where the "CE" comes from column A while the file name comes from column B.

Hi AB33, thank you for replying. I have attached a sample workbook with the code working on the main thread. You have to activate HTML and Internet references.

Also, I tried your code and I didn't manage.

[AB33]

Okay,
It seems the data are the HTML body. I thought you are downloading a file.
My code works, but there is an issue with column B.
The code will error if the file names do not exist. Do you have the file names for all rows on column B?

[exc4libur]

Okay,
It seems the data are the HTML body. I thought you are downloading a file.
My code works, but there is an issue with column B.
The code will error if the file names do not exist. Do you have the file names for all rows on column B?

When you refer to the file names, do you mean the full path ie. "C:\test\file.txt" or just the file name "file.txt".

[AB33]

C:\test\file.txt

C:\test\ is the directory or folder name
and file.txt is the file name

[exc4libur]

C:\test\file.txt

C:\test\ is the directory or folder name
and file.txt is the file name

i have the file names for all rows in column b.

[AB33]

Forget column B.
These code will create the folder for each cell in column A. If the folder exists, it simply overwrites it.

Please Login or Register  to view this content.

[exc4libur]

HAAA!! Saved me, works perfectly. Thank you!