AnsweredAssumed Answered

vba macro to rename files in EPDM vault

Question asked by Joe Shigenaga on Dec 22, 2015
Latest reply on Jul 28, 2016 by JC Veillepeau

Hi,

 

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 ?

 

Thank you,

 

Joe

 

Capture 11.PNG

Outcomes