VBA to rename sharepoint folders and files

[Sidemon]

Hi all,

We are in the process of migrating our file system onto SharePoint 2013 (from shared network drives). We have a number of Excel based tools (Excel 2010) which I am trying to adapt, ready for the migration. One function I am struggling with is the renaming of files and folders. Currently we simply use;

Name OldName As NewName (after first specifying the old and new names as strings).

When I try to run the VBA in SharePoint, I get an 'Invalid procedure call or argument' error and the debugger takes me to the Name line.

Is it possible to use VBA to rename files and folders in SharePoint? If so, any help with how would be very gratefully accepted. I'm sorry if this is a very basic question, I am completely new to SharePoint.

Thanks,
Simon.

 

[manu03]

Hello, I would really like to know if you were able to solve this problem, because I need to perform a similar action, I need to rename a series of folders that are located in SharePoint using an Excel VBA macro but the NAME action does not work. If you managed to solve it, I would greatly appreciate it if you could share an example code with me to do this action.