Hey,
I am trying to loop through a folder to rename pdf files in that folder. I use dir function to do that. everything is fine but when i delete the folder ( which I have renamed the files already) and copy the same folder ( which has not been done) from other directory to give another try.
But then problem took place. Excel still goes through files, which DO NOT EXIST in the new folder any more instead of going through new files.
I guess that data in excel is not refreshing to reflect the files in new folder. Is there any code which I could use to sovle this problem?
Thanks!!!
I am trying to loop through a folder to rename pdf files in that folder. I use dir function to do that. everything is fine but when i delete the folder ( which I have renamed the files already) and copy the same folder ( which has not been done) from other directory to give another try.
But then problem took place. Excel still goes through files, which DO NOT EXIST in the new folder any more instead of going through new files.
I guess that data in excel is not refreshing to reflect the files in new folder. Is there any code which I could use to sovle this problem?
Thanks!!!
