rename the file's name

[Verbamore]

Hi everybody,
I have to download a lot of files. I have URL for each of them.I listed all urls in one excel column.
The problem is when I save the second file. When VBA goes and check for the second url, find the file and when try to save it, the code shows me an error because is another file in the same folder with the same name
How i can put an index so from file1 to go file2?

Please Login or Register  to view this content.

[shg]

Untested:

Please Login or Register  to view this content.

That very first line is one you should get used to using.

[Verbamore]

Untested:

Please Login or Register  to view this content.

That very first line is one you should get used to using.

thanks shg

[shg]

You're welcome.

Please don't quote whole posts; it just clutters the forum.