No announcement yet.

Macro to create folder on Shared drive

  • Filter
  • Time
  • Show
Clear All
new posts

  • Macro to create folder on Shared drive

    hey everyone, this is my first post. For about a week I have been trying to find a macro to solve my issue. I work for a company that uses SharePoint (C drive) and we have a database in excel where everyone places their jobs and job info and then create a folder to place all data pertaining to it. I was able to find a macro that worked for me that copied a folder template and then named the folder based on a cell value, but when i moved it to sharepoint to go live, it will not work because the path is specific to our usernames. There are around 300 people who will be using this database and creating folders and I was wondering if anyone knew what path would work best for this.