I have developed an VBA excel macro to get a files name list in a column, so i can rename them. It is successfully working when I try it in windows explorer.
My problem now is when I try it in a EPDM vault, I can get files name list in the excel sheet but when I rename them, it actually creates new files in the vault as <local file> and keep original files.
I have basics vba knowledge but i'm not an expert and i guess my problem can be easily solved by adding few lines code but i don't know what.
Can anyone helps me ?