Page 1 of 1

Running Macros from SharePoint

Posted: Thu Sep 26, 2024 12:14 pm
by loeb
My company is converting all our network drives from Windows file system on local servers into SharePoint drives. We have a team of 12 engineers who use a shared network location to access our Macros, Materials, Appearances, Templates, Sheet Formats, Blocks, Custom Properties, etc. I predict that SolidWorks is not going to be able to find these files anymore since it will expect typical file system paths which SharePoint doesn't seem to have.

Have you you experienced a change like this and do you have any feedback/advice. I don't see how this could possibly work and not break SolidWorks functionality.

Re: Running Macros from SharePoint

Posted: Tue Oct 15, 2024 6:27 pm
by CarrieIves
I think you may have to set the file locations for each person.

You can have shortcuts to those drives added to your OneDrive show they show up in your windows file explorer. I haven't tried having SolidWorks look to those locations.

If you have PDM, this would be a great time to move all those files to PDM.

Our desktops are now part of our OneDrive (and backed up). I just updated our PDF macro to be able to save to the desktop for desktops on OneDrive. (userdesktop is a string)

Code: Select all

'PDF file Location if saved to desktop (was USERPROFILE rather than ONEDRIVECOMMERCIAL)
userdesktop = Environ("ONEDRIVECOMMERCIAL") & "\Desktop\PDF-EXPORT" 'GETS USER NAME AND ADDS DESKTOP and folder name

Re: Running Macros from SharePoint

Posted: Wed Oct 16, 2024 5:52 am
by retonny77
I love the idea of using OneDrive for saving macros! It seems like a smart way to keep everything backed up and accessible. Just curious, have you noticed any hiccups with SolidWorks when saving this way?