do while loop to change file names

[kchm_2000]

Hi,

I have a list of file names on column F that I want to change that on Col H using a do while or any kind of loop. File Name Changer is the control workbook and the rest are the ones i want changed.

thx in advance to anyone who helps me.

[JBeaucaire]

There's a limit to how big the errBUF can get, so hopefully it finds most of the files properly.

Please Login or Register  to view this content.

[kchm_2000]

thanks it works fine my only issue would what is the threshold? do you have anyclue how many files it can pick up?

[JBeaucaire]

It's a character limit. If you suspect your environment is such that you will have a LOT of these, I'd suggest just marking the rows that fail. This version uses column I to note the failed files for you.

Please Login or Register  to view this content.

[kchm_2000]

thanks for your help it works great