Running Macros from SharePoint

Programming and macros
User avatar
loeb
Posts: 69
Joined: Sun Jan 16, 2022 5:55 pm
Answers: 1
x 39
x 10

Running Macros from SharePoint

Unread post 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.
User avatar
CarrieIves
Posts: 163
Joined: Fri Mar 19, 2021 11:19 am
Answers: 2
Location: Richardson, TX
x 377
x 136

Re: Running Macros from SharePoint

Unread post 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
retonny77
Posts: 19
Joined: Fri Sep 20, 2024 5:34 am
Answers: 0
x 1
x 6

Re: Running Macros from SharePoint

Unread post 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?
Post Reply